I have a spreadsheet and would like to automatically copy the phone number from the "G" cell when the new record in the "D" cell is entered.
I am attaching a sample of the sheet.
IE: In cell D6 (the new record) the name is B. Jones. It is already in cell D3.
I need the phone number in cell G3 to be automatically down to cell G6.
Well, problem is, a cell can only have a value or a formula, not both. So, you'd need to use a VBA Worksheet Change Event handler to monitor column D and, if a new entry matches an existing entry, copy the details down. Not hard if you're ok with VBA but not all people/organisations are.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Where can I find an example of the VBA code?
Thanks
Like this:
Please Login or Register to view this content.
Is this now resolved?
Yes - thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks