Copy partial rows based on value

Closed

maximus - Aug 11, 2009 at 07:08 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 11, 2009 at 08:16 PM

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

Copy partial rows based on value
Excel macro to create new sheet based on value in cells - Guide
We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
Auto serial number in excel based on another column ✓ - Excel Forum
Vba code to move rows to another sheet based on criteria ✓ - Excel Forum
Excel vba copy rows to another worksheet based on criteria ✓ - Excel Forum

1 response

Answer 1 / 1

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Aug 11, 2009 at 08:16 PM

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

Similar discussions

help me to add particular cells

How do I change a base location on Instagram?

Code for macro that conditionally inserts rows

How to add Rows automatically based on Cell Value In Excel?

Duplicate rows based on cell value

Similar discussions

Subscribe To Our Newsletter!