sitelbanat
Board Regular
- Joined
- Oct 17, 2005
- Messages
- 152
how would I write a macro that says
IF column A sheet 1 = "Bank Account Number"
then copy the data in that same row from column C and H to paste them in sheet 2 column A and B
IF column A sheet 1 = "Bank Account Number"
then copy the data in that same row from column C and H to paste them in sheet 2 column A and B