Move Acct Balance Dec 2009 to January 2010

smurr

Board Regular
Joined
Sep 14, 2009
Messages
74
Hello,
I need some advice to move the following:

On December 31, 11:59PM
On Workbook: Household Payments 2009
On Spreadsheet named: Dec

Move: Current Balance on Cell L28


To: Workbook: Household Payments 2010
Spreadsheet: January
Cell L5

Thanks,
Smurr
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

anthonya2369

Active Member
Joined
Mar 10, 2005
Messages
321
Why not just link to the cell now? Open both workbooks, and for L5 on 2010 book, just hit = and then navigate to the other workbook to l28 and hit enter. It will update as long as the workbook is there. If it is not there in a later time, it will keep the number that updated.
 

smurr

Board Regular
Joined
Sep 14, 2009
Messages
74
Followup- Move Acct Balance Dec 2009 to January 2010

Anthonya2369,

Thats a good manual solution

But I would really like the Current Balance on L28 to automatically populate at 11:59PM on Dec 31. See below:

From:
Workbook 'Household Payments 2009' - Worksheet 'Dec' Cell L28

To: Workbook 'Household Payments 2010'
Worksheet 'January' Cell L5

Thanks for any help on this,

Smurr
 

Watch MrExcel Video

Forum statistics

Threads
1,122,536
Messages
5,596,744
Members
414,094
Latest member
dingo_baby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top