Copy formula with source destination

**tek9step** · 12-10-2009, 07:22 AM

Hi

I am sure this is simple but cant get me head around it (tried paste & paste link).. I am wanting to copy formulas in file (A) to file (B) with data source linked in the file (A). All i want is when i copy the formulas to file (B) sheet 2 and it should retain the original path say H:\excel\file A[sheet1]$G$1+....xls and source from which the data is being used.

please could anyone help.

thanks

tek9step

**Huron** · 12-10-2009, 08:13 AM

If you Cut & Paste instead of Copy & Paste, the formulas will link back to the original file. So you can make a copy of your formulas in the original file and cut and paste these to the new file.

**davesexcel** · 12-10-2009, 08:27 AM

Paste,Special,Formulas should work.

**tek9step** · 12-10-2009, 08:50 AM

Thanks Huron & Davesexcel but the problem now i face is how to get the data if the data source file (A) is closed ??

regards

tek9step

**davesexcel** · 12-10-2009, 09:23 AM

Maybe you should open it.

**tek9step** · 12-10-2009, 10:02 AM

There are multiple workbooks so is there a way to source from closed workbook ?

tek9step

**Huron** · 12-10-2009, 10:14 AM

I think most functions should still work except Indirect which will only work on an open file.

**tek9step** · 12-11-2009, 06:56 AM

Hi

I have sumif and vlookup formulas but still the result is not displayed if the file is closed.. I think i shall open a new post as this is a slight different problem.

thanks

tek9step