Copying Data to Another Worksheet - Macro
I am making a large macro for a daily report. After creating the macro, I have to copy over the information to condense it with the previous report. I have done so but its recording the amount of rows I am copying and the row that I will be copying it to. Does anyone know how I can program the macro to copy an undefined amount of information to an undefined row?
I appreciate any advice or help!
Re: Copying Data to Another Worksheet - Macro
This is that section of the code:
Please Login or Register to view this content.
Can you specify which rows from which file should be copied to which file in which cell?
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]
There is no defined number. This macro will be used for various reports.
Both reports have the same format. I guess you can say Columns A-I have to be copied over but the number of rows in both reports will always change.
And the worksheet that I will be copying the information will also have an undefined amount of rows... I am trying to condense the information into one spreadsheet.
Ok, so should data from row 2 to the last row of the source data be copied to the other file?
Now, its row 1. Yes.
From which file do you want the macro to run? The source file or destination file?
Also, will the other file (the one that doesnt contain the macro) be open at the time of running the macro or should it be opened by the macro?
Source file.
Yes. In the macro, it is programmed to open up the destination file.
Can you post that code please?
Please Login or Register to view this content.
Logically, this looks like it should work:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Re: Copying Data to Another Worksheet - Macro
That gave me an error on the vlook up code. My vlookup macro is working perfectly. I just need the section to copy and paste.
Thanks!
I actually found this in another post. I re-worked the information and it worked!
Thanks for the help JBeaucaire!Please Login or Register to view this content.
That code can be re-written into just 2 lines -
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks