Hi guys,
My title is possibly making this sound more simple than it is, as i've spent 2 days researching coding and having a go my self to no avail
I won't try to explain my self, as I feel the example attached speaks for its self.
If someone could advise exactly what I need to be looking for, or write me the code so I can mess with it, I would be eternally greatful!
Thanks
Luke
How about naming the cells with Total Expenditure etc in them as named ranges. You could then just use offset/resize to insert cells as you like relative to them.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Had a play with this during my break. See attached...
Dom
Dom - I can't thank you enough thats exactly what I was after. Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks