0

I have an Excel file where there are 2 sheets: "Upload sheet" and "TemplateClauses" . In the worksheet "Upload sheet" there are formulas that if met they report a value, if not an empty cell.

How can i select the range of cells with values only (beginning from cell B4 until column Z and ignoring the empty ones which contain a formula) copies them and paste them into the sheet "TemplateClauses" as of cell B9?

Improve this question
2
  • Use a filter, copy/paste?
    – BruceWayne
    Commented Aug 16, 2019 at 14:07
  • i was actually looking for a macro that selects the cells with values only and not the cells with formula inside that are empty because there are no values from the source
    – Massimo Guariso
    Commented Aug 19, 2019 at 7:15

1 Answer 1

Reset to default
0

copy the range of cells, hit alt+h+v+v, then re-paste because they are now values

Improve this answer
3
  • i was actually looking for a macro that selects the cells with values only and not the cells with formula inside that are empty because there are no values from the source
    – Massimo Guariso
    Commented Aug 19, 2019 at 7:15
  • thespreadsheetguru.com/the-code-vault/2014/7/21/…
    – samdaily34
    Commented Aug 19, 2019 at 13:44
  • follows the code i am using however it is selecting also cells with formulas where the value is empty cells...: Sub PasteSpecial_Example5() Workbooks("Template_ChargementClausesAPriori_.xls").Worksheets("Upload sheet").Range("B4:Z5004").SpecialCells(xlCellTypeVisible).Copy Workbooks.Open "G:\Global Sales\Accounts\Robbert-Jan Baas\2.PFIZER\Pfizer offer Renewal 2020-2023\Pfizer\5000 loadingSimulation.xls" Workbooks("5000 loadingSimulations.xls").Worksheets("TemplateClauses").Range("B9:Z15009").PasteSpecial Paste:=xlPasteValues End Sub
    – Massimo Guariso
    Commented Aug 20, 2019 at 9:06

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.