Hi All,
Hope you are doing well!
I have been through these forums and cannot find what I need for my requirement.
Below is my requirement and i have attached sample file.
In data tab AUC number (Column P) is unique number, macro has to copy AUC number from data sheet, then find it in Asset List & IO Expense List AUC number column, Fill FA Request Type sheet B2 to B6 cell information from data sheet tab for respective AUS number. Once this is done copy FA Request Type, IO Expense List (Filtered data), Asset List(filtered data) to new workbook and name that workbook with AUS number and save it in defined path. This has to be done for all AUS numbers from Data sheet and create separate files in the path..
Can someone help me on it.
Hope you are doing well!
I have been through these forums and cannot find what I need for my requirement.
Below is my requirement and i have attached sample file.
In data tab AUC number (Column P) is unique number, macro has to copy AUC number from data sheet, then find it in Asset List & IO Expense List AUC number column, Fill FA Request Type sheet B2 to B6 cell information from data sheet tab for respective AUS number. Once this is done copy FA Request Type, IO Expense List (Filtered data), Asset List(filtered data) to new workbook and name that workbook with AUS number and save it in defined path. This has to be done for all AUS numbers from Data sheet and create separate files in the path..
Can someone help me on it.