Previous Topic Next Topic

Copy Data from Main sheet to another Sheet

Closed
mayi1986 - Feb 9, 2015 at 07:51 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Feb 10, 2015 at 01:16 AM
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?

Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 10, 2015 at 01:16 AM
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
0

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Nokia 500
KushalKumarGupta -
ac3mark -

1 response