vba help

Hi Guys, I am trying to use the below to run through values in Column A on a Sheet Named "Report" and Create these ranges in a Sheet called "Holidays_Requested" but everytime I it pops up with Object Required Runtime error 424. can anyone help or know of an alternative way of creating named...

Okay, so Ive read all the threads, and as you'll see in my (other peoples) code, spent some time on Ron's site as well. From that, I have 2 pieces of code working (3 including the function, lets call them C1 and C2), now I need help trying to mend them together. The first one (C1) gets data...

Hi, i have this code for converting a webpge into an excel document, then i can apply a bunch of autofilters on the copied data to manipulate it...i am fairly new to VBA, but using this project as a way to learn it... i have an issue with warning messages....the one at the moment is with when...

Hi, I am working with the following code in order to identify if the selected values are present in "Column B" of other worksheets within the same file. The issue I am trying to solve now is that it just colours the cells with the SAME value but it does not identify those with the contained...

I need some VBA to copy the contents of cell "A3" and paste them in Range H7: "the last row used in column F" and then loop to the next worksheet. What I'm trying to accomplish: I'm turning individual reports (tabs) into a consolidated table (a summary tab), the department name is currently...

Hi Guys, I hope you are all well and had a great holiday season. I was wondering if anyone can help me. I would like to know how to add a new variable to the code below that I am using for a holiday request form. That would say that If Team X is entered allow 2 people off and if Team Y Is...

Hi Guys, I hope you are all well. I was just wondering if anyone could help. I have a holiday form that has Remaing Holidays in B12, Holidays Taken In B13 and requested in E21. What I was wondering if anyone knows how I would have a MSGBOX pop up If B13 EXCEEDS 25 Days or If B12 & E21...

Hey, I was just wondering if anyone could help me with the below. I am trying to only Copy and Paste the rows that exceed "0", I have tried running this code but every time I do I get a run time error. could anyone help me please? an any improvements or suggestions would be greatly appreciated...

Hi Guys, I hope you are all well. I was just wondering if anyone would know how I can amend the below code so that it will only copy rows where the value in column D exceeds a Value of 0 any help would be greatly appreciated Many thanks jamie...

Hello, I am trying to create a Sign In/ Out log for work. So far I have the first half complete, where i can able to record all pertinent data name, trailer number, route, date and time in, but this is a two step process. now I have to figure out how I am going to input the "time Out". What i...

Hi Guys, I was wondering if anyone can help. I am trying to use the below to compile an order of different products. ideally what should happen is that it copies Range B7:D69 to sheet 1 and then you can add another group of products to the next empty row. but what is happening at the moment is...

Hello everyone. I wanted to see if anyone could create some VBA or suggest a better way of doing process that we are currently doing manually. An example file is saved to the Dropbox link below. We hire temporary labor for different events and our departments submit a temporary hire...

Hi Guys, I am using the below upon opening the workbook and have assigned both subs to the Workbook and not sheets. everytime i open the workbook i get a run time error 1004 saying that either the macros are disabled or the sub isnt available in this workbook. does anyone know how I could...

Hi Guys, I hope you are all well? I was just wondering if anyone can help me with the below question. I have 3 different customers each with their own label but the same information follows that label like below. Customer A red+550075110 red+660075110 red+550 red-550075110 red-660075110...

hi Guys, I am currently using the below code for a holiday request form it takes the values on sheet 1: Employee Name : B7 Employee Number : B9 Team : B11 matches them against a reference on their team holiday sheet (determined on sheet1 B11) To Book Holiday in on dates determined in ...

Hi Guys, I hope you are all well today :) I have been using the below to fire off emails to customers. So their Account number appears in Column A & their email in Column B and it then sends off information row by row (C3:I3) to each customer. What I was wondering if anyone knows how I may...

Hi Guys, I have been using the below code to transpose some order numbers Sub TansposeRange() Dim InRange As Range Dim OutRange As Range Dim i As Long Set InRange = Sheet1.Range("B3:B10002") Set OutRange = Sheet2.Range("B2") InRange.Worksheet.Activate InRange.Select...

Hi Guys, I was just wondering if anyone could help me with the below please. I am looking to have all the values from column A Sheet 1 copied to Sheet 2 a1:cm1 but is it possible that once copied that the macro would run through and name that range based on the value in the top cell a1:a5...

Hi Guys, I was just wondering if you could help me. I was wondering if it is possible to have VBA automatically(using a button) run through Column A setting up a named range for each individual value in column A on sheet 2 to a predetermined size (3x10) going along horizontally. So Sheet...

Hi Guys, I was just wondering if anyone knows how I can adjust the below code so it will Copy Cells B21 & C21 On sheet 1 To A Range Defined in B7 The range is on sheet 2 and is the users name Sub CopySheet1A1toSheet2NextCellInColumnA() Dim LastRowSheet2 As Long LastRowSheet2 =...