Forum Discussion
VBA Copy cells after filter
Hi, I've read several other discussions but still can't find anything that seems to match what im trying to do or that i understand enough to make use of. I have a table on sheet 1 which has 1...
I would write a formula in cells Q4 R4 S4 that are =A4, =N4, =O4 (then copy these down, or even better if possible put your data is in a ctrl T Table so the formula automatically fills down) you can then highlight these 3 new formula after filtering P and copy and paste them as values into Sheet3 cell B3