Related:
- Vlook to return data into another worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- How to automatically transfer data between sheets in Excel - Guide
- Zuma return - Download - Puzzle
2 responses
That will not work, I'm wanting to capture information from one worksheet (where the donation amounts are recorded) to another worksheet under the column heading according to their donation amount. For example: In the second worksheet, I have 6 levels of donations ($25, $50, $150, $300,$500, $1,000+). Based on the information recorded on the first worksheet, I want it to display under the correct donation level.
Worksheet #1 - All contributors listed with their donation amount, address etc
Workshett #2 - 6 categories list at top, NEED amount the contributor donated under the correct column according to their donation made.
I believe what I need is the ability to lookup all the donations on worksheet #1 and if the contributor has donated $500, it would automatically list their company name under the column for $500 givers in worksheet #2
Hope that makes sense.
Worksheet #1 - All contributors listed with their donation amount, address etc
Workshett #2 - 6 categories list at top, NEED amount the contributor donated under the correct column according to their donation made.
I believe what I need is the ability to lookup all the donations on worksheet #1 and if the contributor has donated $500, it would automatically list their company name under the column for $500 givers in worksheet #2
Hope that makes sense.
