#1   Report Post  
Old January 12th 05, 11:03 PM
Rob
 
Posts: n/a
Default Excel 2002 help

Hi,

I've been using Excel for years, making spreadsheets for a business,
recording expenditure, income, etc. I'm familiar with most functions within
Excel (currently using Excel 2002), but here's one I hope someone can help
me with.

I have for example, the cash account for 2003. I have separate files for
each month. So January is a separate file from February, etc.

Now what I'd like to do is to carry forward the column/final totals from
January to the start of February.

So lets say the cash account shows a balance of 200 in January, I want that
figure placed as a opening balance for February.

Hope that made sense, and thanks in advance for any help.

Regards

Rob
(email add is fake please reply in ng)





  #2   Report Post  
Old January 12th 05, 11:26 PM
CLR
 
Posts: n/a
Default

Type this formula in A1 of your new sheet and it will link back to A1 of
your old sheet.......drag to suit.........adjust as needed

='C:\YourPath\[YourFile.xls]YourSheet'!A1

Note: this link requires that the file be where you say it is for all
time.......if MIS moves it and/or renames the directory path, the link is
broken.

hth
Vaya con Dios,
Chuck, CABGx3




"Rob" wrote in message
...
Hi,

I've been using Excel for years, making spreadsheets for a business,
recording expenditure, income, etc. I'm familiar with most functions

within
Excel (currently using Excel 2002), but here's one I hope someone can help
me with.

I have for example, the cash account for 2003. I have separate files for
each month. So January is a separate file from February, etc.

Now what I'd like to do is to carry forward the column/final totals from
January to the start of February.

So lets say the cash account shows a balance of 200 in January, I want

that
figure placed as a opening balance for February.

Hope that made sense, and thanks in advance for any help.

Regards

Rob
(email add is fake please reply in ng)








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 08:11 AM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM


All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017