register

I have two sheets named, "Attendance Register" which contains Student Name, RollNo, Class, and attendance status (Present, Absent, Sick) date wise Second Sheet "Summary" i want to count whatever date i entered the cell F2, it show go and check in "attendance register sheet" and count how many...

These are a few things I want to bypass. I am using textbox1 and textbox2 These are for textbox2: 1. The textbox should take only numbers and letters no other character accepted. 2. Letters should not start the entry. So A5 is not allowed 3. After a letter, no more input should be allowed...

Hello All, i have a question regarding a code - i am not sure if it is possible but i hope that there is a way around it. I have to manipulate a register on a daily basis and i am trying to use vba codes to make the task easy. A part of this is to bring in codes from a different workbook- [...

Hi there, First my apologies if there is an answer to this already in the forum, but the amount of info is a little overwhelming and I'm taking the quick route; hope you don't mind. There is a register related to my work that I have to check every week to see whether there are new entries or if...

Can anyone give me advice on where to get help for hiding rows based on what user you are. I have a userform where users will register and then login to access a certain sheet. Once they register it will place them in a certain row alphabetically so when they login I would like to hide all...

Good day, Excelsiors, I am using Power Query to run an API call to our service provider, in order to pull through our platform users and their attendant data. The idea is that we would like to keep a "real time" register, rather than keeping a separate, manually updated register which is...

Hello, i have a document i use for a FOE (forecast of events). It has each colleagues details on and the days which they are away. I use merged cells for blocking out more than 1 days worth of Task/Course. What i need is a VBA to populate a weekly register to say whos here or not. It needs to...

Hi All, Happy belated new years greetings to you all. I need your help on my query. I have 2 spreadsheets. Spreadsheet 1 is the main register and Spreadsheet 2 is a schedule. Linking all required details from S1 to S2 is ok using VLOOKUP function except for the last part of the schedule...

I'm supposed to create a platform that provides me with a .txt ansi formated file from my invoice register. Does anyone around here has any idea how to this? Or maybe even how to start learning how to format in ANSI for dummies from an invoice register created in excel? I'm super new to using...

I want to set up an invoicing system that has a front invoice page, a customer database and an invoice register. So far I have set up vlookup on the main invoice page to pull in details from the customer register but now need to save each invoice for each person to a register. Ideally I would...

Morning All, I need your help on my query. This is my query. I have 3 spreadsheets in a workbook which the first spreadsheet is the data entry spreadsheet and the other is the quotation form to fill automatically from the details from the first spreadsheet. The 3rd spreadsheet is my register...

I have several worksheets contained with a single file. One worksheet is a check register, and another is Expense worksheet. I need to find a value on the check register based on both a date and category. I have used IF statements and VLOOKUP to find values based on single values, but...

Hi, I need to register invoice data to new workbook. Can you help me please.

My check register has stopped working properly. The formulas won't work together such as <tbody> </tbody> =IF(AND(ISBLANK(F85),ISBLANK(G85)),"",H84-F85+G85) =IF(AND(ISBLANK(F86),ISBLANK(G86)),"",H85-F86+G86) These are from 2 total lines in my spreadsheet (ss) that works Now This next formula...

I am working on a workbook that will have four sheets, each is a bank register. The first is the main register that houses every transaction associated to the entire account. The remaining three are what I am calling "T-Accounts". In Column "I" (labeled "T-Account") there will only be three...

I have budget worksheet that I use and it works very well. I am trying to have a check register on another tab for that month with drop down categories that will automatically change the values in my budget. For instance if I budget $300 for groceries and I go to the store I want to put into...

Hello I have created a registration userform. People come to the PC, enter they badge number and register for an event. After they register the userforms background turn green. => registration OK If for some reason the user try's to register again the userforms background turns red. => Already...

Hi I've just become a member of this site so if I do something wrong please dont jump too hard on me.:biggrin: I have a spreadsheet which brings data from another workbook depending on the criteria specified. E T U V Area Month YR...

Hello all, I am trying to create an At risk register so i can track my student that have several classes. Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...

Hello all, I am trying to create an At risk register so i can track my student that have several classes. Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...