nirvehex
09-29-2014, 11:56 AM
Hi,
I have a VBA code:
Code:
Sheets("Recommendations").Select
Range("A3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("Client Pre-Bid").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
It pastes in data from one sheet tab to another. The range varies in number of rows. Once the data is pasted, how do I add in the formula "=countif(A2:end of last row pasted,"Yes") into the row below the last row pasted?
Thank you!
I have a VBA code:
Code:
Sheets("Recommendations").Select
Range("A3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Sheets("Client Pre-Bid").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
It pastes in data from one sheet tab to another. The range varies in number of rows. Once the data is pasted, how do I add in the formula "=countif(A2:end of last row pasted,"Yes") into the row below the last row pasted?
Thank you!