| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
consolidate values to a checklist on sheet 2
Hi,
I have an invoice on sheet 1. There are carton numbers listed in the A column on random rows. The rows that do not have a carton number are blank in the A column. How can I create a checklist of the Sheet 1, column A values on sheet 2 with no blank rows on sheet 2? In addition, some of the carton numbers are 5 or more digits and I want these separated from the 4 or less digit carton numbers. Any suggestions would be much appreciated. -- moviestar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
| Save only values of one sheet | Excel Discussion (Misc queries) | |||
| linking values from one sheet to another | Excel Discussion (Misc queries) | |||
| Values in 'Balance sheet' template are in $ I want £ but there is. | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
