My problem so far is trying to combine data from separate sheets into one.
In other words, just an update without deleting prior data.
I have some code here that will shed some light;
Please Login or Register to view this content.
My problem so far is trying to combine data from separate sheets into one.
In other words, just an update without deleting prior data.
I have some code here that will shed some light;
Please Login or Register to view this content.
If you already do have data that you don't want to overwrite, then it sounds like you simply need to first determine where that data ends. The new data you add will be added after the data you already have.
This statement might help.
last_row = Cells(Rows.Count, 1).End(xlUp).Row
It determines the last row in column 1 that has data in it. Your data would start at last_row + 1, for example.
How can I incorporate last_row = Cells(Rows.Count, 1).End(xlUp).Row into the above code?
I ended up being able to transfer data without having to delete prior.
Now Im having trouble selecting the column headers along with the data when added to previous data.
I dont want the column header, just the data.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks