Various table copy and pasting needed

[Falcons88]

Hi,

I have posted a few things recently that have really helped and I really do appreciate every bit of help I get. I am creating a bookkeeping template for my mate to use (he's recently become a sole trader), I know what I need but I don't have the knowledge of VBA to do it which is why I've been asking for help. The latest thing I'm trying to do is as follows:

I am trying to copy certain cells from "Input Sheet" into various tables I have set up in "Chart of Accounts" sheet, the tables are set up with below names:

Revenue	credit	table1
Direct Costs	credit	table2
Overhead	credit	table3
Fixed Asset	credit	table4
Current Asset	credit	table5
Current Liability	credit	table6
Non-current Liability	credit	table7
Equity	credit	table8
VAT	credit	table9
Realised Currency Gains	credit	table15
Accounts Receivable	debit	table16
Historical	credit	table18
Rounding	credit	table19
Retained Earnings	credit	table20

I have set up each table with the below headers:

I am trying to copy from the example below, B7 into [Date], A5 (there is white text in there) into [Source], E7 into [Reference] along with H for each item listed with column L determining which table it goes into.
To make things even more complicated I was needing the figure in H to go in either [Credit] or [Debit] determined by Column L (as matched with list above)

"Input Sheet"

I hope this makes sense and again I really appreciate the help.

 

[jkpieterse]

Set up an intermediate row somewhere out of the way with the same headings as your target table (perhaps immediately above or below that table is a good idea). Then in this intermediate table, use direct cell references to the cells that need copying: =B7 for Date, =A5 for Source, etc. For the debit and credit you can use something smarter using the IF function, I'm sure you'll figure that one out.
Then all your code needs to do is copy the intermediate row into the table.

 

[Falcons88]

Set up an intermediate row somewhere out of the way with the same headings as your target table (perhaps immediately above or below that table is a good idea). Then in this intermediate table, use direct cell references to the cells that need copying: =B7 for Date, =A5 for Source, etc. For the debit and credit you can use something smarter using the IF function, I'm sure you'll figure that one out.
Then all your code needs to do is copy the intermediate row into the table.

Thanks for the advice, I knew I was overcomplicating things lol