| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I would assume this is possible
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 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 F57 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 | |||
| Am I to assume... | Excel Discussion (Misc queries) | |||
| What would Excel Assume if DATE left blank | Excel Worksheet Functions | |||
| Can I assume everyone has Scripting Run Time (scrrun.dll) on C:\WI | Excel Discussion (Misc queries) | |||
| assume the number I type is in the thousands | Excel Discussion (Misc queries) | |||
| Can I assume the program has crashed? | Excel Discussion (Misc queries) | |||
Hybrid Mode
