How can I automate lining up cells in excel or open office?
March 24, 2008 3:06 PM Subscribe
Is there a way to automate this very tedious spreadsheet task?
posted by [expletive deleted] to Computers & Internet (14 answers total) 2 users marked this as a favorite
I am currently aggregating the sales and inventory data for three stores that share inventory. Unfortunately, the software we are using won't allow us to export both sales and inventory in stock to the same spreadsheet.
To make matters worse, we can't delete unused inventory codes, so my inventory export is 18000 rows long. A sales export will typically only use between 500 and 2000 of these codes, and I have to go line by line, inserting cells so the sales data lines up with the inventory. Line by line, for 18000 rows. I have to do this three times, once for each store.
To make things even worse, I've been suffering from intense migraines lately, and this isn't making them better.
I was wondering if there was a way to automate the process of getting cells with a given code, and the associated cells with the sales data to line up with the cells of inventory data. The codes are a letter or series of letters followed by a dash and a 4 digit number, for example A-1134, ECO-0045. A few codes for various reasons don't adhere to this standard, like OM-4 or H-2334.5.
If this isn't clear, I'll try to provide a concrete example.
I use Open Office at work, but I have access to Excel if needed.