User Profile
NicholasCombe
Copper Contributor
Joined Mar 15, 2023
User Widgets
Recent Discussions
combine data from specific cells from multiple sheets
Hi there. I have been trying to find out a way to do this and searching, but perhaps I'm not using the right questions. I have a sheet containing income from returning recycling containers for a 10c refund for each month. Each month is exactly the same layout, so the summary of refund value for each month is always C29. We always donate 25% to 5 charities, but the charities change each month. How can I make a summary sheet, that creates a table with the summary of the money received for each month? I also want to create a summary sheet for all the charities that we donate to over the year. So far I have just been copying and pasting, but the data changes as we update it each month.
