Previous Topic Next Topic

Copy rows from one worksheet to another works

Closed
Gowind - Mar 2, 2011 at 05:08 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 4, 2011 at 04:52 AM
Hi ,
I'd like to know if there's a macro that can be run to check one worksheet. In this worksheet there is a column where the value should be "true". If this value is true, I'd like to copy the entire row of data into another worksheet which resides at server.Its very urgent anybody please help me...
There can be multiple rows of data where this condition is met.

Any suggestions would be greatly appreciated.

Thanks

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 4, 2011 at 04:52 AM
autofilter according to that column being "true" then copy the filterd data to another location
remove the autofilter after copying is done.
0

Similar discussions

copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

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

8 responses
Code to move rows into another sheet based on certain values
nathaliecannell -
vcoolio -

1 response