Hello..
Can anyone help me with the following excel vba coding...
I have three workbooks and what I need it to do is to look at sheet on worksheet one, look at columns A to U starting on row 7 and delete the the data down until in all cleared.
Now it looks at workbook2 sheet1, look at columns A to U starting on row 7 and copies all the data down untill it gets to the a emplty row, thens paste this all this wookseet1. Then looks at worksheets2 sheet2, and copies the same as above into the next empty row in workbook1.
It then looks at workbook3 and copies the same as workbook2 into workbook1....
Does anyone have a idea on the coding for this task...
Thanks inadvanced for the help on this ...