I did come across this: which could be a viable solution (I'm really not sure if it applies, but would like to test it...). However, where would I i...
Thank you for continuing to help me Catalin! The .Update function did not work either. I also tried .RefreshTabl and I'm in the process of resea...
DoEvents did not change anything. 🙁 I am still experiencing some sheets/connections that are not refreshing even though they are commanded to do s...
This gets rid of the error, but the values all come back as 0 which is not accurate. Ideally, I'd like to have the dates as columns and the skus as ro...
Intriguing...I have not ventured into using Powerpivot yet...but I've been looking for a good excuse. Looks like I found one. I'm sure this will bring...
I would compile the raw data listing how much you scrapped, on what date and what length of product it was along with the cost, then you can create a ...
Thank you - one follow up question - what command can I use to only paste values & formatting. Currently it is pasting the formulas which I do not...
This did it - THANK YOU!!!! 😀
The sheet names in column one look accurate - and I confirmed that the defined name is SheetList in my database too. I did change the name of the t...
Thank you Catalin! So helpful! I am trying to use the 2nd code you sent for printing certain pages, but when i inserted it into my active workbook ...