Copy partial rows based on value

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!