vb script

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...

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...

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...

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")...

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...

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...

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...

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...