Related:
- Vlook to return data into another worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Digital data transmission - Guide
- Activeworkbook.worksheets current worksheet ✓ - Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
2 replies
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.