Hi there, went to register an account and it seems I was here nearly 10 years ago! How time flies... So, here's another problem my google-fu isn't good enough for:

I'm trying to create a fairly simple pair of spreadsheets for the owner of a shop to keep track of takings. One is the database, a simple list with columns: Date, Cash and Card Takings, and Cash and Card Bank Payments. The other, I'd like to specify a year and month, and have it populated by the data in the list corresponding to that month. I know how to do that. What I want, however, is when the data does not exist, I'd like to be able to enter it in the "monthly viewing" sheet, and have that copied over to the full database, to simplify and organize the data entry process.

So basically, is there any way of dynamically linking two cells across spreadsheets to allow both pulling and pushing of data WITHIN the dynamic cell? Will it require a seperate "Save" macro (as clearly I can't enter a formula within a cell that will need to accept user input)?

Thank you for any suggestions or advice