Previous Topic Next Topic

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

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
mathewmunna -
mathew munna -

2 responses
How to add Rows automatically based on Cell Value In Excel?
Raj_2823 -
TrowaD -

7 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses