MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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!!!