lollipop1471
New Member
- Joined
- Oct 18, 2016
- Messages
- 4
Hi,
I am new to vba and would really be grateful for any help please.
I would like to copy 2 cells, from a spreadsheet with many rows, based on a criteria on another cell on the same row, into a new worksheet, on the next available row.
Then i would like the cursor to come back on the new worksheet cell T1
And i would also like for when the macro is run again, for it not to enter the data again if it is already there.
Sheet 1, looks like this:
Copy payment type and Amount based on Channel
Thank you
I am new to vba and would really be grateful for any help please.
I would like to copy 2 cells, from a spreadsheet with many rows, based on a criteria on another cell on the same row, into a new worksheet, on the next available row.
Then i would like the cursor to come back on the new worksheet cell T1
And i would also like for when the macro is run again, for it not to enter the data again if it is already there.
Sheet 1, looks like this:
Copy payment type and Amount based on Channel
| Customer | Payment Type | Amount | Address | Channel | Region |
Thank you
