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
Bookmarks