vb script

  1. derek.hughes

    Script to - subtotal and remove duplicates with lower subtotal

    This sheet has thousands of rows of data, but this is a "snippet" of what I am trying to accomplish. <tbody> Name Bargain Unit Pay Class FTE John Doe 220 15 0.05 John Doe 220 15 0.10 John Doe 220 15 0.10 John Doe 220 20 0.50 John Doe 220 20 0.25 </tbody> I have employees that work...
  2. U

    Create new sheets

    I have an excel sheet (version 2010) with 359 company names in col A. I need to create a sheet for each of those names. I have been doing this manually and I've completed 129 so far but this is super tedious! Is there an easier way for me to do this? I've never written a VBA script or a macro...
  3. G

    Saving a copy as PDF by saving the XLS file

    Every time I hit save in my excel (.XLS) document, I would like it to save a copy as .PDF. I would like to be able to specify what directory the PDF is saved in (ideally it would be different from the directory that the .XLS file is in). The PDF file name should be the same every time and...
  4. R

    I have a VB script that works in 2003 great but will not work in 2007

    I got this VB script last time here. And it works great in 2003. But now we have 2007 and it does not work can you help me. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$3" And Target.Value = "HideDues" Then ActiveSheet.Unprotect ("cover")...
  5. E

    VBA Help - Complex - Moving rows between Tabs

    Hi, I have a spreadsheet that has 2 tabs 'Retrieval' and 'Master' I have a button on 'Retrieval' with this code attached that needs these changes: 1-Instead of copying I need it to 'Move' the rows selected to 'Master' tab. 2-I don't want it to clear Master tab first. It actually needs to...
  6. derek.hughes

    VB Script to hide/unhide worksheets

    I made a spreadsheet with employee leave balances. There is a "HomePage" worksheet with instructions, and each supervisor also has their own worksheet with their direct reports listed. I added a VB script to each worksheet to password protect them and gave each supervisor a password. This...
  7. WERNER SLABBERT

    macro or vb script to do the impossible.

    Would it be possible to write a macro that will allow you to print the same document on two different printers and save the workbook to a specific folder according to a name in a cell to a specific path. eg: in cell A1 the Text = U15420 in cell A2 the test = Goedehoop now on the network...
  8. M

    Prompting file name dialog box in VB and using the name in cells

    Hi, I'm trying to prompt a user to select a file (without opening it) and then use the file name to generate links in the source file, pointing to specific cells in the selected file. My code so far is: ' createNewEntry Macro ' ' Filename = "='[" & Application.GetOpenFilename("Excel...

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