Need Excel Equivalent for Lotus' old Slash, File Combine
Posted by Jim McDonough on May 25, 2001 1:36 PM
Combining files seems very tedious. I have to map each cell from each spreadsheet to another total spreadsheet to combine files. With my old Lotus program I just used the / file combine commands and was done.
Is there a similar function in Excel?
Posted by Barrie Davidson on May 25, 2001 1:47 PM
It's been 6 years since I last used Lotus, what does the FILE COMBINE command do?
Barrie
Posted by Jim McDonough on May 25, 2001 1:59 PM
I am looking to basically have 12 monthly excell "sheets" totaled on one summary year to date sheet. With Lotus, I just formatted a blank sheet and entered each months figures and then saved the sheet. To get a year to date sheet, I'd just use the combine comand to add the YTD sheet to the current month sheet to get an updated YTD sheet which I would save under a new file name.
Does this explain it more clearly?
JIM
Posted by Barrie Davidson on May 25, 2001 2:15 PM
Assuming the twelve sheets you refer to are in twelve different files, you can link to all twelve in your YTD file. The formula, in cell A1 in your Y-T-D file, would be (linking all values in cell A1):
='C:\[January.xls]Sheet1'!A1+'C:\[February.xls]Sheet1'!A1+'C:\[March.xls]Sheet1'!A1+etc.....
CAUTION - if your files are set up this way, updating the links can take a very long time.
Assuming the twelve sheets you refer to are in the same file, and each month is in a separate worksheet, you could input the following formula in your Y-T-D worksheet (assuming your monthly worksheets are in month order and your Y-T-D worksheet is before the monthly data):
=SUM('January:December'!A1)
I hope this is clear enough for you. If not, let me know.
Regards,
Barrie
Posted by Jim McDonough on May 25, 2001 2:27 PM
It sounds sooo simple. I'll give it a try.
Thanks!!!
