hub

Hi all, Workflow below ALL Code resides in sheet "Super Automation" Information is gathered on "Ads" tab and brought into "adstemp" Advert Data is opened and relevant tours gathered Advert Data closed, tourlist is loaded into Automation Hub Several spreadsheets are now opened (Regional Press...

Hi, I have two bugs that are crippling the workflow of the company. We rely on probably 40-50 different workbooks that are very macro heavy and do a lot of talking to each other, like one is a database of adverts and the other reads it, displays adverts to select and then applies new lines to...

I have a column that is basically a description field. It may or may not contain both invalid characters, and hidden, or non-printable characters. I want to use regular expression to remove the invalid characters and replace them with " " (a space). so for example a-z, A-Z 0-9 are acceptable all...

Hi all, Thanks in advance for anyone who looks and helps me on this one, that is driving me crazy. I am looking to create a page that looks up each of my separate areas, and then returns a Top 10 (1-10) for each area with account number and the value outstanding with that account. I am...

Hi all! I've created a user form in which I submit data on orders i'm following up on. 5 other co workers have a copy of that workbook. Every time we click the "Submit" button on the user form, it adds the form data to the next blank row in the current workbook, but it ALSO adds the form data...