I am pretty new to all this and unfamiliar with macro's and script, but I do have some very basic formula knowledge. However I cannot figure out the following. Could someone please be so kind to advise?
I am trying to create a summary of data on another tab in Excel. Basically, would I would like to do is:
If cell range F4 to F40 on my worksheet tab named INVOICES is not empty then copy the row of each non-empty F-cell to rows 100 to 136 on a worksheet tab named SUMMARY. All empty rows need not be displayed on SUMMARY
Would that be possible with a formula? Which formula? And in which cell or cells on which worksheet tab do I need to enter it?