Hi,
I am looking for a macro to copy over information from one sheet to another depending on a few things
I have a a few sheets set up with tables in them like below:
I am looking to copy over certain information shown below to the relevant table in the relevant sheet:
example above
On line 9 the information from N to U to go into a sheet called "Revenue" to a table I have set up titled "Sales" named (table1)
On line 10 the information from N to U to go into a sheet called "Asset" to a table I have set up titled "Office Equipment" named (table2)
Column L is driving which sheet it goes into and column F determines the table.
If it's possible I'd like VAT to go into a separate table too but not sure if that's able to be done
any help would be fantastic, if anyone can think of an easer way otherwise as i might be complicating the process would be greatly appreciated.
I am looking for a macro to copy over information from one sheet to another depending on a few things
I have a a few sheets set up with tables in them like below:
I am looking to copy over certain information shown below to the relevant table in the relevant sheet:
example above
On line 9 the information from N to U to go into a sheet called "Revenue" to a table I have set up titled "Sales" named (table1)
On line 10 the information from N to U to go into a sheet called "Asset" to a table I have set up titled "Office Equipment" named (table2)
Column L is driving which sheet it goes into and column F determines the table.
If it's possible I'd like VAT to go into a separate table too but not sure if that's able to be done
any help would be fantastic, if anyone can think of an easer way otherwise as i might be complicating the process would be greatly appreciated.