Copy Data from Main sheet to another Sheet [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I have a document that has a quote on the first sheet. What I want to do is if the code in column C meets a certain criteria, it will automatically copy to the corresponding sheet.

Example...

In Column C, the code is CAR. I want the entire row with CAR to copy to the "Carpet Install" Sheet. There could be only one row with CAR or there could be multiple.

When the lines copy over to the correct sheet, don't want to see empty rows in between, i just want to see them listed.

Can anyone help?

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
I shall give you an idea

autofilter whole date for column C having "CAR" as full value.
you can copy (alt+c) filtered data and paste anywhere you want.

will you try