Search results

I have been struggling with this for a while now and cant seem to get this update to work. I have a table that holds a project id, a line ID and then the percent allocation to each service line. I am trying to calculate the percent allocation based on the number of repeat project id's IE: 1...

Hello all, I'm using some vba to transfer an excel spreadsheet into an existing table. Is there a way to stop the transferspreadsheet command from automatically choosing the datatype? I think this is the problem because when the first few rows of a specific column are blank I get Type...