copy columns to other tabs based on searched value

M

Marty

I have a challenge on a sheet that we are using for order tracking that
I am hoping someone can help me on.

The first tab is called the "master" it contains our product list and
pricing in columns A - F
columns G-AL contain the order quantities for each store (and new
columns are inserted into this range as orders come in) columns AO-BG
contain a bunch of calculations for orders to date by product etc these
will always be shifted to the far left side of the sheet

Row 7 contains a region code for each store , say CHI (chicago) NE
(northeast)

I need a macro to search row 7 for the region name and then copy and
paste that entire column to the matching region tab

Is there an easy way to do this?

THANKS in advance!

Marty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy row based on value into new sheet of same name 9
Copy/paste in based on duplicate value in previous row 0
Hide Columns Based On Date Value 1
use month in cell date to sum all relevant cells 2
Delete columns based on a cell reference date value 4
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Total columns Based on another cells value 4
Hiding Columns based on cell value 3

Top