Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with macro or formula
hi all, Need some assistance. Have a spreadsheet shows 4000 warehouse locations (location of products). Each cell is a location in the warehouse; some products have more than one location. I import a text file into the wookbook which tells me which product has more than one location (2, 3, 50, etc) if a product take up more than 1 location, the location are always next to each other. What I’ve done so far is to use vlookup to look at locations in file and allocated the number (the number of locations the product has) to the cell that correspond to that location. What I need is a macro or formula that will look at the cells and the number within and than highlight the cells next to it according to the number in the cell (5 in cell, highlight 5 cells, 50 highlights 50). The warehouse runs up one aisle and then down the next and so on. So I need to be able to highlight cells up one column and then down the next and then up, then down and so on. Possible? Hope I’ve explained myself clearly, any assistance would be appreciated, really, been at it all day Cheers -- JAZZNAURA ------------------------------------------------------------------------ JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961 View this thread: http://www.excelforum.com/showthread...hreadid=572971 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Macro Formula revision? | Excel Worksheet Functions |