Hi, I'm trying to adapt the VBA code from this thread into a loop. The aim is to copy and paste a range of cells (Name Range "Output") for each scenario that I'm running into a numbered list (Name Range "Paste.Index"). There are 10 scenarios that are numbered 1-10 (Name Range "NumScenarios") and whichever scenario is chosen is shown in the cell (Name Range "ActiveScenario"). My intention is for the macro to cycle through each of the 10 scenarios and then copy and paste values for each scenario based on the location in the list for that scenario. So for example, if scenario 5 is active, then the macro would copy "Output" and then paste the values next to where the number 5 appears in a list. For some reason the code refuses to paste anything past scenario 6 and it pastes over some of the older pasted values for some reason. Any help would be greatly appreciated.
Hey man i have a question.... what if you want the option to find next option. Let me explain, so lets say you forgot the whole name of the person but you have multiple similar names of a person lets say you have john david, john arthur, john miles, john george but you only remember john so how do you go to the next option? Is there a way?
Very Helpful video sir,
Thanks alot. Do watch other videos also. Share it with your friends/ colleagues/ family members.
Sure sir..
Hi, i want to search my invoice value in another workbook and replace the invoice amount with new amount. Can you help me on this, thanks
Hi, I'm trying to adapt the VBA code from this thread into a loop. The aim is to copy and paste a range of cells (Name Range "Output") for each scenario that I'm running into a numbered list (Name Range "Paste.Index").
There are 10 scenarios that are numbered 1-10 (Name Range "NumScenarios") and whichever scenario is chosen is shown in the cell (Name Range "ActiveScenario"). My intention is for the macro to cycle through each of the 10 scenarios and then copy and paste values for each scenario based on the location in the list for that scenario. So for example, if scenario 5 is active, then the macro would copy "Output" and then paste the values next to where the number 5 appears in a list. For some reason the code refuses to paste anything past scenario 6 and it pastes over some of the older pasted values for some reason.
Any help would be greatly appreciated.
Vba excel, sheet1 cell A1 is content need search, if content appears in file word or excel in a folder, b1 is path file result have appears . how ?
Hey man i have a question.... what if you want the option to find next option. Let me explain, so lets say you forgot the whole name of the person but you have multiple similar names of a person lets say you have john david, john arthur, john miles, john george but you only remember john so how do you go to the next option? Is there a way?
Your list contains only men's names.!!
Hahaha. That was just a random list I created a while back and used in my videos. I will add few women's name too in next video. 😉
@@LearnExcelVBA 👍😉