Did a quick check and modified your formulas so that when you copy them you do not need to check the references. I think this will work If you a...
Hi Paul, With Windows 2013 you probably mean Office (Excel) 2013. The calculations you need only take place in row 3 to 8 in the 'Wk SQN Calc' s...
Okay, I misunderstood your question. I'm not in the mood to rewrite your code right now but let me see if I understand you correctly. In Sheet 2...
I don't knwo where you're looking but it show's up in the dropdown
Looking forward to see a file and the new pricelist file will help understand. Don't forget to mention the Excel version you're using
@Sherry Fow, I'm missing two macros, Save_BackUp Insert_End Since you also addres diffrente Sheets like Sheet7, Main, I suggest you ...
I'll have to read the code you have more thouroughly. The problem lies in the file names used
Try using this section of the code like this, check the red text ' Save Backup file ' Save COPY of Active Workbook (with new filename) 'Path o...
Make sure the filepaths are correct for each file. Can you attach the template file with the values in the different sheets? Just some dummy dat...
Since you're using ThisWorkbook.Name it's the name of the currenbtly active file whihc is the saved file Instead just refer to the B2 cell text to ...
Aside of a sample file I suggest you also mention the Excel version you're using
And the Excel version????
I also suggest you state the Excel version you're using
Hi, Can you tell us which version of Excel you're using?
Maybe try slicers and an extra filter like grouping per Menu option?