| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to mass populate cells?
I was given a data pull from Quickbooks. The invoicing data is set up so I
can't do pivots, vlookups etc. With 2000 Rows I need an automated way to fill in cells so I can those type tasks. The data looks like this: A2: Name of Company (Example: ACME Manufacturing 45673 A3: Blank A4: Blank A5: "Total ACME Manufacturing 45673 B3: "Invoice" C3: Date of Invoice D3: Invoice Number E3: Product Name F3: Qty G3: Sales Price H3: Amount I3: Balance B4: "Invoice" C4: Date of Invoice D4: Invoice Number E4: Product Name F4: Qty G4: Sales Price H4: Amount I4: Balance The same layout for about 600 Companies... How do I get the name of the company in the empty cells. In the frist example to be in cells A3 and A4. Then remove Row 5 so I can then do my own SUBTOTAL and Pivots? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I populate a cell with another cell's value based on condit | Excel Worksheet Functions | |||
| how do i set up drop down menus to populate cells in excel? | Excel Discussion (Misc queries) | |||
| REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
| populate a limited # of cells with a set value | Excel Worksheet Functions | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
Linear Mode
