Good day
Can you please assist with the vba code for the attached excel sheet.
If cell: AP3 = 2, to copy cell: AF11 and paste to cell: D2
also if cell: AP3 = 3, to copy cell AF12 and paste to cell: D2
I hope this makes sense
Regards;
Good day
Can you please assist with the vba code for the attached excel sheet.
If cell: AP3 = 2, to copy cell: AF11 and paste to cell: D2
also if cell: AP3 = 3, to copy cell AF12 and paste to cell: D2
I hope this makes sense
Regards;
Can you please change the title to something that more accurately describes your problem, because otherwise it's hard for us to navigate through a bunch of generic titles?
About your issue, you don't need vba for this.
You can simply use in D2: =VLOOKUP(AP3,$AE$11:$AF$20,2,FALSE)
Never use Merged Cells in Excel
The reason why I cant use a formula on D2 is because if cell: AP3 = 1, then D2 will be a manual entry
Here, use this within some other code:
![]()
Please Login or Register to view this content.
Hi,
this in the Modul of your Worksheet:
BR, Alexandra![]()
Please Login or Register to view this content.
Thanks a lot it work perfectly
You´re welcome!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks