tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Bit stuck with this,
please help.
I have two workbooks
1 called "Sales Doc" Sheet is "Invoices"
the other I need to only call this workbook sheet "Raw Data"
All I want is a macro called "Mark_AS_Paid"
that when I run, takes all the Invoice numbers from "This workbook" sheet "Raw Data" Column A
Finds them in Workbook "Sales Doc" Sheet "Invoices" Column A and marks that row in column T as "Yes" and Column U as "Today"
I'm struggling as there are different workbooks and I don't know how many Rows of Data there will be in "Invoices"
please help
Tony
Bit stuck with this,
please help.
I have two workbooks
1 called "Sales Doc" Sheet is "Invoices"
the other I need to only call this workbook sheet "Raw Data"
All I want is a macro called "Mark_AS_Paid"
that when I run, takes all the Invoice numbers from "This workbook" sheet "Raw Data" Column A
Finds them in Workbook "Sales Doc" Sheet "Invoices" Column A and marks that row in column T as "Yes" and Column U as "Today"
I'm struggling as there are different workbooks and I don't know how many Rows of Data there will be in "Invoices"
please help
Tony