How do you copy data from one cell to another if a different cell has a specific value.

[ryanbodi]

Hello! I need help copying data from one cell to another on a different sheet. If cell E2 on Jan equals 101 then copy data from cell B2 on Jan to cell C3 on Sheet1.

I hope that is clear enough. Any help is very much appreciated.

[GeoffW283]

I'm assuming that you are not restricting this to January but wish the formula to work for all months. If that's the case then to make things much easier the month names in Sheet1 row 1 should match the worksheet names.

I'm guessing that if there are multiple entries with the same account number in Jan then you are looking for the sum of those entries on Sheet1.

I also notice that you can have multiple rows on Sheet1 with the same account number (at least for account 131). Will Sheet1 col-B entries always exactly match Jan col-D entries? I have assumed so. If not then I see no way to apportion account 131 expenses between "Insurance" and "Property taxes".

On sheet1 in cell C3 copied down and across to N23:

Please Login or Register  to view this content.

See the attached update to your workbook (I added a few extra test cases)

Hopefully this works for you. Let us know.

[ryanbodi]

Thank you! I got it to work with a little modification. Works perfect! The only other question I have is there a way to sum up the cells in the columns in sheet1. I'm assuming its not looking at the data as numbers you can sum up. Any suggestions?

Thanks for all you help. It's amazing to have a group of people like everyone on here that's willing to be so helpful.

[Estevaoba]

In your original file, paste in C3 and copy across and down:

Please Login or Register  to view this content.

Good luck!

[GeoffW283]

The only other question I have is there a way to sum up the cells in the columns in sheet1. I'm assuming its not looking at the data as numbers you can sum up. Any suggestions?

Thanks for the feedback, but I'm not certain what the problem is. I added, as an example, to Sheet1 cell C24:
=SUM(C19:C23)
Which (with my Jan data) gives $505 total for Fixed Expenses.

If I'm misunderstanding and you still have an issue, then please attach an updated workbook that shows the problem.