Copying Data from one sheet to another sheet on a specific day

G

Gav123

Hi,

I want to be able to automatically copy data from one sheet to another sheet
on the last day of the month (the sheets are in the same workbook) when the
user opens or saves it (either way would be fine)

On sheet 1 there is a running total say cell C3 and on sheet 2 the
destination cells Jan, Feb, March etc.

Is there a way to have my running total populate the correct months figures
while keeping the previous months total. Just now the user manually inputs
the figures but if I can automate this task it would save time for the user.

I hope that I have explained the problem clearly enough.....

Any help you can provide would be appreciated.

Gav.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup whole sheet and add datas from specified date to end date 0
Copying data from one sheet to another on a specific date 3
how to copy and paste value from one sheet to another 4
Creating a Chart on form from selected data in query. 0
Drop Down List Dependant Formula 2
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Copy entire row from another sheet onto first sheet if a unique text matches 1
Copying cells from one sheet to another 5

Top