Macro for autofill address in excel 2007 [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,
i am using excel 2007 prepare my sales invoice, i have maximum 10 to 15 purchaser, so i
am using validation for selecting purchaser. i have the purchaser details (address,zip, contact) in another sheet , so i need macro to auto fill the address after selecting the purchaser form drop down list.Because i have used V-lookup but its not working after copy and paste of invoice in another cell.

thanx,
if u will forward my answer step to step i will be highly obiliged to u.

Prahalad


1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi Pal,

V-lookup can still work for you you, as long as you use paste special - values.
This will paste the values instead of the formulas which will give an error because the cell reference changed.

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!