Excel Select Range Copy Paste issue

0
votes

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?

1
excelcopyformulapaste
Use a filter, copy/paste? – BruceWayne
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

1 Answers

0
votes

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