Morning,
I have a file that has a table containing various expenses cost lines about 8. The table is filtered using a drop down list of about 35 businesses all numbered using 4 digits. E.g business number 1189 . The problem with this table is that it only holds 1 week worth of expenses for each business. I want to copy these Figures to another workbook with each businesses on each separate sheets so I can track each businesses expenses week by week e.g
Business 1189
Wk 1. Wk2. Wk 3. Wk 4
Expense 1
Expense 2
Expense 3
Expense 4
Is there a code to do this. The file name for the expense is named wk1 or wk2 etc the new file is called total expenses
Thanks in advance
Alan
I have a file that has a table containing various expenses cost lines about 8. The table is filtered using a drop down list of about 35 businesses all numbered using 4 digits. E.g business number 1189 . The problem with this table is that it only holds 1 week worth of expenses for each business. I want to copy these Figures to another workbook with each businesses on each separate sheets so I can track each businesses expenses week by week e.g
Business 1189
Wk 1. Wk2. Wk 3. Wk 4
Expense 1
Expense 2
Expense 3
Expense 4
Is there a code to do this. The file name for the expense is named wk1 or wk2 etc the new file is called total expenses
Thanks in advance
Alan
