VBA: Moving contents of cell from one cell to another based on dropdown criteria.

[Emmaizzy]

Hi All

I'm not really sure how to sum up this query in the title so I will try to explain what I am trying to do here.

Every month I receive a list and/or receipts of expenses - these are numerous. Each individual expense needs to be recorded into a spreadsheet. Row A has the category headings, ie, Food (Column B), Entertainment (Column C), Travel, Management Costs etc in individual columns. The rows underneath list the details of the expenses. For example a receipt for a supermarket would be listed on Row 2, Column A (A2) as 'Waitrose" and then in the food category (B2) the amount on the receipt would be entered. A receipt for the cinema - 3A, amount listed in the column 3C for Entertainment.

As I there are so many to enter I find it simplier to enter all the expenses and the expense value and then drag this value to the correct column, however, it is a very time consuming task to make sure when you are dragging the values they remain in the right row and then column, particularly as the spreadsheet gets larger. What I would like to do is enter all the descriptions and amounts and then using a drop down select the correct catogory and this would tell excel which column the value needs to go into. For example if I had Cinema in A2 and the amount in Column B I could use a dropdown the catgorise the spend and it would automatically move the value from Column B to Column C.

I have attached a workbook which I hope explains what I am trying to do.

I would be so grateful if someone could help me with this as I cannot find anything on Google.

[AliGW]

Welcome to the forum.

You can't do this without VBA. Shall I move the thread for you?

You CAN post your workbook.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[Emmaizzy]

Hi Ali

Thanks for the reply - please move my post to the right place.

I think that until I have created more posts I'm not allowed to do attachments, images, links etc.

[AliGW]

Yes, you CAN attach a workbook, even as a new member, and I have just explained how! I think I should know, don't you?

[Emmaizzy]

Sorry Ali - I didn't mean any offence - I misunderstood what this message meant when it appeared "You are not allowed to post any kinds of links, images or videos until you post a few times."

[AliGW]

No worries. Please do upload a workbook - it will help. I have moved the thread.

[Emmaizzy]

Done - thanks.