Hello,
I am trying to create what I thought would be a simple VBA script to move data but I cannot seem to get it to work correctly. I have attached a mock up of what I am referencing. I included what columns need copied from (sheet 2 or 3) to (sheet 1) in the mock up.
I am trying to grab data from specific columns in 2 sheets and paste that, in the same order, in the first blank row on the main sheet (sheet 1). Essentially this consists of 3 sheets. When a button is clicked on the main page (sheet 1), it copies the specific column data from its corresponding sheet (sheet 2) and pastes those columns in order on the main page (sheet 1) in the first blank row. A different button will do the same but copy from (sheet 3) to (sheet 1) instead.
The problem im running into is having a code that runs 2 buttons corresponding to the other tabs and not pasting over itself on the main sheet. It is important that the data it pastes stays in order and it does not save over itself if you hit the button again. I do not have a table on this spreadsheet for other reasons.
I tried to use macro recorder but it saves over the data already there and splits the columns randomly down my main sheet out of order. I also cannot find any similar posts because this needs to gather specific column data from other sheets and paste them into one 'main' consolidated sheet. So apologies if I missed this being answered elsewhere.
Any help would be greatly appreciated and if I can find something that works it will make my life so much easier. I appreciate anyone who can help me.
Bookmarks