Previous Topic Next Topic

Macro for autofill address in excel 2007

Closed
pal - Dec 27, 2010 at 02:40 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 27, 2010 at 08:19 AM
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


Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 27, 2010 at 08:19 AM
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