I having trouble writing a macro to take the first table below from a tab in one Excel file and past it into the last empty row in another file. Any guidance would be much apprecaited
This is the data that current exists in a seperate file
I am trying to copy only the "Type" column (and change it from vertical to hortizontal) into a tab in a seperate file but the trick is that I need to copy this data into the next row which contains no data. Effectively, the goal is to add a new row of data everytime the macro is run.
Thank you Excel gurus!
This is the data that current exists in a seperate file
Name | Type | Total | Price |
1 | 0.70 | 4.14 | $ 101.00 |
2 | 0.71 | 4.15 | $ 102.00 |
3 | 0.72 | 4.16 | $ 103.00 |
I am trying to copy only the "Type" column (and change it from vertical to hortizontal) into a tab in a seperate file but the trick is that I need to copy this data into the next row which contains no data. Effectively, the goal is to add a new row of data everytime the macro is run.
Type | 0.70 | 0.71 | 0.72 |
Thank you Excel gurus!