Need help creating a sheet

Copper Contributor

Hi Everyone, 


I need help creating a sheet that can pull yesterdays data from multiple sheets to one main sheet that we will be printing from. I basically want to streamline/automate the sheet a little. I want the "Daily Cash Up" to automatically pull data from the previous day so that all i have to do, is capture the data on the "Main Data" sheet and the "Petty Cash" sheet.


I have created an example on the first sheet and put some data onto the second sheet. Is there someone who can perhaps help me with this. I can email the document through. I would highly appreciate it. 







3 Replies
Hello @DonevinK

How much experience do you have with MS-Excel, writing formulas, using some features such as filtering, sorting, and possibly some Visual Basic for Application language to automate MS-Excel?

I think you should use this as a learning platform under the auspicious of "Give a Man a fish you feed him once, Teach a Man how to fish, and you feed him forever"?



I have basic knowledge with excel to be honest. I wouldn't call myself a pro.


I do work with various formulas on other sheets that we use in the document. I am currently looking for some advice on creating and setting up this sheet for our company's Reception with regards to receipting and petty cash. 

Why do you have to pull the previous day transaction into the current day sheet?