worksheet arrays

I'm implementing a 'live' and self-service reporting regime. I want managers to be able to access their own area's live data and take a snapshot of it at any point in time by saving selected sheets to a pdf file on their respective Desktops. The macro I've put together runs without errors - but...

Hi, I am hoping someone can help me out with this, I've been searching online but cant figure out how to do it. I need some help with VBA syntax for a macro button to do the following: Find all instances of the word "Main Contractor" across an array of 12 worksheets (MS001.......MS012) &...

Thank you in advance for any help provided. I am looking to produce a work book with numerous tabs, but for this example I will just focus on two work sheets. First work sheet I have columns A,B and C populated across serveral rows. Second work sheet I have the same columns however in each...

Hello, This is my first post on this forum. I have been tasked with compiling data from the same column in many sheets (290). -The sheets are all in the same workbook and have an incremental name (SO17000-SO17290). -The column contains data that looks like this: 6129/110 I need to compile...

Hey everyone! I am still pretty green with VBA, but I know enough to get stuff done. But, I've found myself in a bit of a rut with a spreadsheet that I'm working on. Long-story-short, I am trying to write a private sub in a specific worksheet that will call a certain UserForm when the lowest...

Hi All, Can someone please assist me. I have created a multi select listbox in VBA that will create new workbooks based on the user selection of listbox items. I have written the following code which works great for single selections. However if index item 0 and 1 are selected two new workbooks...