Copy partial rows based on value

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I'm hoping someine can help me...
I'm new to visual basic and I'm looking for a code to take the data from an excel spreadsheet, sheet 1 and place the data into a new sheet; sheet 2, but only if the value in column f is > than 10 if this value is < 10 i want it to ignore it and go to the next value and loop until all information with values greater than 10 are pasted into the new sheet (sheet 2), The value in column f is calulated bassed on the aswer given in column d.
I am trying to have this function performed at the click of a button.

I hope i haven't made this too complicated...

Thanks in advance,

Mick

P.S. running office 2003

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
Why do you want vba(or macro). you can just autofilter according to column F(custom filter >10) and copy the filtered data to anywhere you like

If you still want macro post back
0