If Cell = X, Copy Entire Row Into A New Sheet

**Mr. McGoo** · 07-07-2009, 04:07 PM

First, I want to say this forum has been a life saver! I have searched quite a bit and have learned alot, but I am stuck on solving this problem and hopefully someone smarter and more excel talented can help me out.

I track sales in 9 different dealerships and I enter the all the information you are seeing manually.

Excel 2007....

What I need is a foruma to read column "I" (SR) - and see which showroom was selling it (CN, TN, HU, etc), and then copy the entire row (A-Q) and place it in another sheet that corresponds with the appropriate showroom.

To the right of my data I designated what each letter combo stands for and to which new sheet I need these added to.

I want to thank this community in advance for any and all help. It is much appreciated. Please let me know if you need any more information...

Marc

**alewis** · 07-08-2009, 11:43 AM

Insert the following code into Sheet1 in VBA

Please Login or Register  to view this content.

There may be better ways but this works. No when you put an 'x' in column R the data i transferred to the correct sheet. I have attached the file with the code in it.

**Mr. McGoo** · 07-14-2009, 09:48 AM

alewis - thanks so much. I just now saw your response.

I will be honest - Visual Basic is completely foreign to me. Without being too much trouble - how in the heck would I apply that to my current spreadsheet?

If it's too much to ask, I completely understand...

**alewis** · 07-15-2009, 05:30 AM

Perhaps there is an easier way,without using VBA. You could perhaps make everything a lot simpler and keep all the data in one spreadsheet and then use the built in autofilter function to simply select the car maker you want. To do this, go to the master table (sheet1 in yor example file and click anywhere in the data). Then either hold down the Alt key and press 'd' followed by 'f' and then 'f' again or select the filter button from the data tab. This gives drop down boxes for each column in the data.

Otherwise, let me know more specifically what you are trying to achieve and we can develop the code.

**Server2008R2** · 07-15-2009, 11:40 AM

i have almost a same problem but i need to copy entire row (only 4 parameters) in another sheet but insted of X I need to use A-1, B-2 and so on, also it need to be copy in vertical colomn

**Mr. McGoo** · 07-16-2009, 09:12 AM

Originally Posted by alewis

Perhaps there is an easier way,without using VBA. You could perhaps make everything a lot simpler and keep all the data in one spreadsheet and then use the built in autofilter function to simply select the car maker you want. To do this, go to the master table (sheet1 in yor example file and click anywhere in the data). Then either hold down the Alt key and press 'd' followed by 'f' and then 'f' again or select the filter button from the data tab. This gives drop down boxes for each column in the data.

Otherwise, let me know more specifically what you are trying to achieve and we can develop the code.

Thanks so much. I think I can get that to work. Not exactly what I am wanting, but should work...

Thanks for your time...