badge

  1. K

    Macro to copy and paste specific values

    I volunteer for my local scout group and wish to create a report that shows which badges have been completed, which are in progress and which have not been started. This is to make building a program easier as we can see what badges to work around. Currently we use a system that allows us to...
  2. B

    Creating a Tracker in Excel for Employess on/off jobsite

    I currently have an excel workbook and sheet that allows me to use simple functions like (If(ISNA(VLOOKUP)) where I only have to enter an employees' badge # and the rest of their information populates to the right of their badge # (to include the time of the inputted badge #, meaning the time...
  3. S

    Delete rows based upon duplicate Data

    I have a very large spreadsheet that has several rows of data that are duplicates of other rows, except for data in one cell. For example, A B C D E <colgroup><col width="152"><col width="80"><col...
  4. S

    Copy and paste from one sheet to another based on a cells value

    Hi All, I have a spreadsheet that populates the employees time and attendance. I am trying to create a new tab that will only pull the data for lateness's from the main tab. <tbody> Area Badge Payroll No. Name Basic x.1.25 x1.5 x2 O/T Total Late Holiday Sickness Bank Holiday 04 Unpaid Holiday...
  5. T

    Match up data based on pre-existing data

    Greetings, I would like to develop some code that would line up rows of data with cells that have matching values in column B & C on the same row. Clear as mud I know!!!:laugh: It would be easier with a picture! Anyway...I have a list of badge numbers in column B, rows 7 thru 11 as 1,2,3,4,5...
  6. S

    Match cell value to range

    Hi, Can anyone help with this code? I cant seem to make it work correctly. I am trying to find cell (A1) value's match in range ("B:B"). And then populate sheet 4 (report) column D with the corresponding username found in sheet 2 Associate Table. I have a table, sheet 2 which has cell A1 RFID...

Watch MrExcel Video

This Week's Hot Topics

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
Top