It's been over ten years since I last worked with VBA so I am rusty to say the least.
I have a spreadsheet with a simple table in Sheet1 with columns Date, Name, Amount, Type. The user simply adds items with Amount & categorises items using the Type column. In sheet2 I have a table with columns Date, Name, & columns for each of the Types...Food, Beverage, Other, Gas, Supermarket. Sheet2 will be populated using VBA & the data input in Sheet1. What I need is code which will:
In Sheet1 taking one row at a time grab the Name, Amount & Type
Go to Sheet2 place the Name in the Name column
Check what Type the item is....it could be Food, Beverage, Gas, Other, Deposit
Grab the corresponding Amount for that item
Goto Sheet2 & find the column with the corresponding Type & place the Amount into the row for that item
If the Type is Deposit the amount should be placed in the Deposit column
and then repeat for the next item
So when the code is executed the Item is placed in the Item column & then going across the row I could see the cost & what type it is in.
The aim is to have Sheet2 with the costs placed in the correct categories so it looks kind of scattered. I should point out the area where the amount is to be placed is conditionaly formatted & I would like to maintain this as much as possible.
I really don't know where to start with this one I have attached a quick mockup to help. I hope I have explained this clearly however if anyone requires further information I will be happy to oblige. Any help will be greatly appreciated.