I currently have set up a data collection template in excel for Project managers to complete. Once this is returned to me all this data needs to be copied into another spreadsheet (One row per project) ready for importing into excel.
I have a simple macro that will copy into the first row only but I would like to be able to copy many of the questionaires into the second worksheet before importing to access, to do that the macro will need to copy into the next blank cell.............ideas
The whole copy paste macro is made up of about 30 of these commands for different cells pasting into the same row of the sheet "SOA_ACCESS_TEMPLATE"
Windows("SOA_TEMPLATE.xls").Activate
Range("B4:H4").Select
Application.CutCopyMode = False
Selection.Copy
Windows("SOA_ACCESS TEMPLATE.xls").Activate
Range("B2").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
I need to add something into the code that will paste in the next Blank cell ?
Any ideas would be appreciated as I have not had much experience with VBA.