register

Hi, I am stuck and need some help please. In my excel workbook I have two worksheets namely "Payroll Register" & "TAX Rates & Rebates" I am trying to reflect the employee's TAX Rebate based on his/her age as per the following table; The "Payroll Register" worksheet contains the employee's...

Morning All, Within my department we use an excel based job register for employees to add engineering issues as they occur. Currently someone within my department has to sporadically check the register to see if any new jobs have been added and then assign them to an engineer and give it a...

Hi I want to populate a userform combo/listbox - RowSource from a dynamic range that I created in a Sub according to which cell is clicked on (using activecell.offset). What do I specify for RowSource? Do I need to register the range name - how? Thanks for any help David

Hello- I would like a macro to copy an entire row of data, based on month of transaction. I have identical headers from Row 1-6 and column A, on the register sheet and each month sheet (January, February, March, etc" Data is in sheet "Register" from B7:AC500. The date for each transaction is...

Hello and I need some help with defining a macro to do the following. My excel file has 2 register; "export" and "archive". At the end of each month I want to copy each line entry from register "export" that has a date stamp within that month and paste it into the register "archive" below the...

Hi, I have just become involved in VBA and macros Its a new Challenge in my retirement I have followed to the letter the VBA code shown in you You Tube Posting Learn Excel - Create an Invoice Register - Podcast 1808Finding it extremely helpful However when I compile it I get error messages The...

Hi, I have set up my own stock control with Purchase orders. Using a VBA I save the PO to a register and also save a pdf copy to another folder. i would like to open the PDF from the Register using a hyperlink (this i have completed), but it only opens the folder with the PO's listed. How can...

Sir , I have a query with starting register number and ending Register number of a batch of students how can i create a report as given below (for Eg. starting reg.Number 346 and ending Reg.Number 483) REGISTER NUMBERS FROM TO 346...

Hi guys, how are you all? encountered a big problem and now I am hoping you can help to solve it... So basically to build a register for my book using indexmatic I need a list of the words looking kinda like this: /(wierer)|(Albin Wierer)|(Wierer Albin)/ => Albin Wierer The Names between the...

Hi folks I have a wb with an ever growing number of sheets. I also have a register on my first sheet storing details of each sheet contents. I'd like to create a hyperlink on the register page to jump straight to any sheet based on the sheet name stated in Col A. I've tried a number of things...

This might be super easy but here goes. I need to see if a "Product Name register mark" lives in column C. If it does, then the register mark for that Product Name needs to be eliminated in column AB. Also, I need to see if a "Product Name" has a register mark in the first instance, then it...

First and foremost, I want to apologize for my ignorance with macro coding and VBA, now with that being said, I am VERY new to the sport (somewhere nearing a week), and this is my first post. After watching several MrExcel youtube videos, I have been able to create a worksheet named "Receipt"...

I am trying to make a register for my students. Along the top being the date and student down the side at the end i have present abcent and late. I am trying to populate a sum for the month end. The formula i have used is =COUNTIF(B3:F3,"p") All date cells selected and if p inserted then it...

Hi all, Windows 7, Excel 2010 I have an add-in with UDFs. I want explanation of the function arguments in the function wizard and also be able to click for Help in the wizard. So I register the functions like this: Application.MacroOptions macro:=Range("afsfunctienaam")(i), _...

<tbody> I am a martial arts instructor and I keep my attendance records in an Excel workbook. There is one worksheet for each of four schools, a Master and a Consolidated (as the students are allowed to train at more than one venue, so I need to have a record of their attendance at their...

Hi all I'm trying to create a macro to basically record attendances at meetings. So far, my macro opens the right sheet of a different book, enters the names on the left most column, the date at the top of the next available row, and deletes any duplicated names. What I want to be able to...