Macro for autofill address in excel 2007

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 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
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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 2821 users have said thank you to us this month