extract data with formula from 1 excel sheet to another

[rk68]

Hi,
I have an excel sheet which has multiple formulas & each row has member id.
I have written a macro to extract data & copy it to multiple excel sheets as per the member id.
The issue is the new excel sheets created has only values & not the formulas.
How do I extract the data to another excel sheet along with the formulas.
These extracted sheets would mailed to respective member id so there shouldn't be a link to parent excel sheet.

TIA
Raj

 

[SkipVought]

Hi,

How do I extract the data to another excel sheet along with the formulas.

Copy n paste.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[combo]

Use Copy method with Destination argument set. If you don't need formats, use PasteSpecial method. For exact formula copies (without references shift in case of relative addresses) you can use DestinationCell.Formula=SourceCell.Formula.
In the first two cases you shouldn't get external links if in the copied formulas in the source worksheet there are no references to other sheets.

combo