Hi, I have a set of data that I will be using different criteria to filter.
I will need to
1) copy some columns of the filtered data without headers, and paste into another existing sheet.
2) as the pasted sheet has other columns (with formulas), i will need the formulas to extend to all the pasted rows.
In my attached file, there are 14 possible rows that can be copied over to the Output sheet. I am trying to copy columns A, B and H over to Output. But as you can see I also have formulas in Columns F, H and I in Output. It has to be applied whether the filtered data has 5 or 10 or 14 rows. How can i ensure that the formulas will be applied to however many rows are pasted?
thanks very much!forum.ozgrid.com/index.php?attachment/71240/