Using Multiple Drop down List to populate Multiple Ranges

Hello All,

With Help of several here i have the following code Working Great.

If possible, i would like to eliminate several VLookup formula's i have and go with VBA code so i dont have to go in and Change Multiple formulas anymore.

I have Drop down boxes from "B2:B37" that populate "D:R" of respective lines
.. Even lines look at "Combined Data" Tab
.. Odd Lines look at "Offset" Tab


Ive tried and can get it to copy over the format "boarder's only" but not the Data itself.

Is there a way to use the Copy & paste part of this code multiple times?

Please Login or Register  to view this content.

Thanks Again
Aeneren