Hi Guys,
I have in my opinion a challenge with some VBA, but im sure there is a wizard in this forum who can help!
I have three sheets that need to work in unison with each other. This is how I think they should work.
Sheet1 (Entry Sheet)
All the information will be entered here and populates specific fields on the others.
Once the data has been entered I would like a button to do the following
Copy the contents from Sheet2 Range (A4:S100) (Not all the rows will be used each time if that makes a difference I only need the values and not blank rows)
Then paste into sheet5 Range (C2:U100) – (This form will be used as the upload file into our system)
If possible create a copy in a new workbook to be emailed
Once complete and a copy of Sheet5 has been created the contents of Sheet one needs to be cleared and the number increased by +1 (cell J5)
Cells to be cleared (C5,G5,G7,G8,B11:100,F11:F100,G11:G100,I11:I100,J11:J100
Any help would be greatly appreciated
Rosco
I have in my opinion a challenge with some VBA, but im sure there is a wizard in this forum who can help!
I have three sheets that need to work in unison with each other. This is how I think they should work.
Sheet1 (Entry Sheet)
All the information will be entered here and populates specific fields on the others.
Once the data has been entered I would like a button to do the following
Copy the contents from Sheet2 Range (A4:S100) (Not all the rows will be used each time if that makes a difference I only need the values and not blank rows)
Then paste into sheet5 Range (C2:U100) – (This form will be used as the upload file into our system)
If possible create a copy in a new workbook to be emailed
Once complete and a copy of Sheet5 has been created the contents of Sheet one needs to be cleared and the number increased by +1 (cell J5)
Cells to be cleared (C5,G5,G7,G8,B11:100,F11:F100,G11:G100,I11:I100,J11:J100
Any help would be greatly appreciated
Rosco
