Copy/Paste macro

[bpflyr]

I have a worksheet (Summary) with a lot of formulas on it. Can anyone help me write a macro that will copy just the text and results (no formulas) from worksheet Summary (in workbook BLogbook) to workbook PDA Summary.

In worksheet Summary:

A,D,G,J 1:34 are all text
B,E,H,K 1:34 are all formulas that generate number results

Thank you so much!

 

[acw]

Hi

Something like

Workbooks("pda summary").Sheets("sheet1").Range("A1:K34").Value = Workbooks("BLogbook").Sheets("Summary").Range("A1:K34").Value

You will have to update for the sheet name in PDA Summary (I've assumed sheet1). Also, both workbooks will have to be open for this to work.

HTH

Tony

 

[bpflyr]

Thank you so much!!