Jerfyjer169
New Member
- Joined
- Oct 30, 2018
- Messages
- 7
I did some research on how previous posts may help in doing what I want. Those may be a little too complicated for me to understand as I have only came across VBA recently.
I have a list of invoices that are ready for payment. For each invoice that is due for payment, I will mark it as "Y" in Column A otherwise blank. I will need to archive each row that is marked with a "Y" in Column A on the "Archive" spreadsheet.
What I want to do is, if Column A is not empty, then highlight that row, copy and paste value on the next empty row on the archive spreadsheet.
Would VBA be the best option for this? If VBA is the best option, how should I go about this?
I have a list of invoices that are ready for payment. For each invoice that is due for payment, I will mark it as "Y" in Column A otherwise blank. I will need to archive each row that is marked with a "Y" in Column A on the "Archive" spreadsheet.
What I want to do is, if Column A is not empty, then highlight that row, copy and paste value on the next empty row on the archive spreadsheet.
Would VBA be the best option for this? If VBA is the best option, how should I go about this?