Hi, help please
I want to do a change in the Code below which copy data from Worksheet 1 to others Worksheets but instead of copy the info in the first Row I'd like copy the info starting in the Row 60.
What changes is necessary to do
Thank you a lot for the time of everybody
Please Login or Register to view this content.
If you want to copy the data from row 60 onwards to the next worksheet, change this lineToPlease Login or Register to view this content.
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Arlette thank you for your answer...I did the change you suggest but start to copy data from Row 2 instead of 60
Do you have a sample file that i could test with?
OK..attached is a sample...thank you
Your test file does not have any data from row 60 onwards.
Hi Arlette...this is the point I need to copy the data in Wsheet1 in the others Wsheets starting in row 60
What if you have fresh data in the "Data" tab, do you want the data in the other sheets to be cleared and fresh data inputted or should it be input below the existing data?
Will the sheets already be created in the file? If yes, will the headers be already present?
Hi,,,good questions......When I have fresh data I want to be clear every cells starting in Row 60 and put the new data starting in that Row...in other word I have Rows of each Wsheet populated with info in Rows 1 til Row 59, that is why I need to clean Rows 60 and below and put new data starting in this Row..Thank you for your time
Should the headers be copied to row 60?
Yes, the headers must be copied to row 60
Edited your code....Please Login or Register to view this content.
Thank you Arlette for all your time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks