mutiple workbooks

  1. A

    Split specific columns into mutiple work sheets delimited by a column as well

    Good afternoon, I was searching the forms and thought I would find the input to my hurdle. I am trying to extract records from a detailed worksheet into separate sheets but only specific columns. I thought I might find a script for each of these two steps and merge the scripts together, but I...
  2. L

    Opening and closing multiple files

    Hello, I have a code that works great. The code opens all the files in a folder and compiles it to a table on my master spreadsheet. The problem I have is that when the program opens the files I have to click on update for each file because they all have link to a database. It's a lot of files...
  3. J

    Creating mutiple workbooks from multiple worksheets

    Hi Excel Gurus, I have what I think is a simple problem requiring a simple VBA solution. I have huge workbook that has over 60 worksheets. The first 3 worksheets belong to Finance and the names all start with "Fin_xxx","Fin_yyy",etc. The next 7 sheets belong to HR and are prefixed by "HR_xxx"...
  4. L

    VBA to use vlookup with multiple workbooks

    Hi I am a newbie in vba and would like to seek help in a problem that I am facing. I am using excel 2003. I have 15 similar files in which I want to extract data using vlookup. The range to look for is F3:T43, and the info I want to extract are in column 2,5,6 and 7. I want to put these...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top