Hello
I’ve been a longtime lurker around these parts first post.
I was hoping to make this an add-ins so eventually when I receive this email every day I could just click the button.
Had a great search, got some ideas but never an exact match
I'm self-taught from forums so struggle but have some basics
An extract of the email I get each day is attached
Extract.xls
The final product is in CA History (this is saved on our server)
I manually find the highlighted rows and copy and paste the information from "C" “F” “I” “K” “T” “V” “X” into the other sheet it can reach 5000+ lines
The first 5 rows never change and what I was hoping was to first Select C6
Then create this
Find first non-blank cell in column “C” (or the first cell that contains the account number which is 5 numbers)
Copy this value
Copy offset values in “F” “I” “K” “T” “V” “X”
Paste in CA History
Then find the next blank
– repeat
Thoughts if this would be the best method?
Has anybody attempted this recently and could give me an example?
Or better still would somebody help me please?
Thanks Glenn
Bookmarks