Automation of excel spread sheet
I followed this through to step six, thinking you could record a macro
once to do this then replay it again in the future. I got a bit lost at
6a, though, and at Step Seven, and I'm not really sure what you mean
about using the "concatenate formula all the way down the spread sheet"
or having "mis-matched invoice numbers" that you have to work around.
I'm sure you could automate all of this, but you would need to describe
things a bit more clearly in the latter stages. Rather than concentrate
on what you do now, perhaps you could tell us what you want to achieve
and describe the format of the data that you have to work with.
Pete
cprocha wrote:
I receive a daily report; I need help in automating this process.
Step one: highlight the entire spread sheet
Step two: expand the columns so I can read the information
Step three: de activate highlight
Step four: go to columns N thru Z) and set the date. (Format date and time)
Step five: go to Colum (AA) format alignment. Get rid of wrapped text.
Step six: Hard part because this always changes depending on the report.
6a- I have to highlight the rows and insert tree spaces. The reason this is
difficult is because I have matching invoices that need to be grouped
together all the way down.
Step Seven: after all the spacing in the rows is in I need to copy the top
row of all matching invoices and copy it one row above where I copied it from:
On the copied row I have to use the concatenate formula all the way down the
spread sheet
Example:
Copied Row - 12345 cat dog worms
Original row- 12345 cat dog worms Also a matching invoice.
Matching invoice 12345 cat dog worms
Matching Invoice 12345 cat dog worms
Through out this sheet we have miss-matched invoices numbers we have to work
around.
Step seven: I have to use the (Sum) on column (H) then copy to (Columns I,
J, K) all the way down where I used the concatenate formula.
Step eight: go over to column (A) and wrap the text. Format, alignment,
wrap text
Step Nine: Copy and paste the wrapped text and use the (PASTE as Special)
choose values for every row where I used the concatenate and sum formulas.
Step Ten: delete all unused rows to clean it up.
Is there an easier way to do this?
Thanks in advance
|