Thank you Veouria, I'll take a look there didn't think of it. I used RdB's tips often bue didn't realize JPK stated hosting them for him
Maybe I overlooked it but hopefully the SEQUENCE() function works with the OP's Excel version ???
Move the macro modules to a Module and run it again
Hi Scotty, glad to hear it helped. I suggest you take a look here; it explains it in a great way and has helped me to try out new ideas and put it ...
Hi, I don't know if this helps but just a few days ago I read the tip to use the built-in function N() If an interesting function that shows the ac...
Hi Kyle, First tell us which Excel version you're using Second, a copy of your file as sample removing private/sensitive data?
Hi Chris, about the file on Z-drive, what you can do is place a link (shortcut) to that file on your desktop, that way it's always there another optio...
Hi Scotty, sure you can you keep the SAP import page. What you have to do is in a new worksheet create a table (ListObject) as you want it and then...
Excuse my butting in. I read your last entry, and you say your file is saved in the C desktop. I always tell everyone to avoid storing actual fi...
Hi, No Excel version mentioned, but that's probably no issue here. One thing you could try is to use .Text instead o .Value. If the error pe...
I agree 200% with Riny, incomplete or unclear questions result in incorrect or no answers at all and do not leave the questions to interpretation of a...
What Riny mentions is clear. First, I would advice you when posting to tell us which version of Excel you're using. My suggestion would be a tab...
Hi Steven, these attachments are not a file as Philip requested, they're still pdfs. I also suggest you tell us the Excel version you're using. Mak...