Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change columns after a certain cell
I have created a sheet called WORK ORDER where all of my product options are
listed. I made it so that if an option was not picked, the cell that contained that option would be blank. I then wrote a code in VBE that would delete all blank cells in WORK ORDER. What I would like to have happen now is have the new condensed list reach a certain point (A63) and the remaining portion of that list move over to F14 and work its way down to cell F57 if needed. If the list continues after that point I would need the remainder to start on J1. I am having fits with this for some reason, so if anyone has a similar code or knows how to go about this, it would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
How do I change numbered columns to alphabet columns? | Excel Discussion (Misc queries) | |||
How do I change my cell reference columns from number to alphabet? | Excel Worksheet Functions | |||
Can you change the name for your columns from A, B, C, ETC to oth. | Excel Discussion (Misc queries) |