I am looking for some help please, I am sure it is something simple.
When I enter a numerical value into the Userform textbox "txtRTAs" I would like it to look at a worksheet to see if the number is there. IF it is, then I want a simple MsgBox to inform that this number is there and "banned"...
I have come across a code which am having hard time with. I need the userform information to be entered into another sheet, which is not working. I need the Macro to update the table with new/edit previous information.
My Data range is B2:F11 with a flag in corresponding row cell in A2:F11
This flag in A2:F11 is EITHER of 1 OR 0
Output required as in H2:L11 as:
If flag is 1, then corresponding row in H2:L11 SHOULD BE ‘SAME’
If flag is 0, then corresponding row in H2:L11 SHOULD BE ‘REVERSED’
Hi I hopeyou can help, I am trying to make a post code lookup, so for example inTextBox51 you type in your postcode like ‘WR5 3’ then automatically it updates textbox52 with the area of the postcode for example ‘Worcester’. It gets the data from my sheet called ‘PostCode’and looks at row A for...
I have two sets of data, each set has several columns of data. I want to be able to flag any rows that have two numbers that are identical? Here is an example:
I hope that link work let me know if it doesn't.
I want to flag the right column (M) only if the...
I'm trying to flag data that appears since the last time the report was refreshed. For example, if the sale date was 28/07/19, flag this row as "new since last refresh", if the record wasn't present on the last report version. Any ideas please, guys?
I've Googled about and looked through...
Hi all, got a quandry here.
Let's say I have a table like the below:
I have no idea where to start on this one
I have a row of columns that would contain days of a month e.g 31
On a row I would like to flag a sequence of 15 in one cell and the next right being 9
Ignoring all other combinations e.g 15 15. Or zero 15 or 9 15 - only to flag a 15 then next...
I've been searching around and can't quite piece together how to achieve this.
I want to apply conditional formatting to a pivot table. This pivot table contains a list of names for the rows, and weeks on the columns. The values are the sum of hours. Data that is...
I am very new to VBA and all the codes.
I need help with this VBA which I copied from the website or something else I should do.
The problem I face:
columnA1 - the formula =IF('2018-2019 Semester Data'!U81=0,"",'2018-2019 Semester Data'!U81)
The actual data from...
I have a query that's connected to a file that's supposed to automatically every day. Today, for some reason (not my issue), the file wasn't there, but my query didn't tell me the file was missing. Can I flag the query so that if the file is missing it alerts me?
I need to set a Yes or No flag for a list of vendor numbers based upon whether or not they appear in another sheet and have an associated positive dollar value. I use this Yes/No flag to decide which statements I have to create and print at the end of each month.
Currently, I use a...
Hi, need some help. Below is an example of my data which comes from a very large database. Column B is a date that can be when the client renewed their terms with us (if the client is listed more than once) or originally signed with us (if listed just once). I want to put a formula in column C...
I'm working on my project, but i'm stuck. I search all around the web to get somme idea to finish it. But i can't tell google the good way to find it.
I work on a formula, to keep track of my information automatically on another sheet.
I got on my sheet1 13 cell to backup on my sheet...
Is there a formula that would let me flag that last ten weeks from current date, taking into consideration that week 52 (sometimes 53) rolls back to week 1
For example.... Below is column A (The date) and B (the flag) I'd like the formula to look at the date in the cell and if the date in the...
In my score sheets, I was thinking to come up with a way to flag certain cells that I can visually associate with certain characteristics. For example if a student was sick and got a low score, I want that cell to be flagged. And I need my formulas to be able to recognize these flags...
Hi all. I'm trying to fill the list box (ActiveX) with names that have an active flag and skip names who don't have an active flag.
I created an named range that refers to both columns and entered it...
Hi all this is my first time here so please be gentle.
I have a basic sales board consisting of reps, days of the week, double sales and single sales, mandates and total. Each mandate can be a single or a double but what i need is a formula that will flag the mandates cell if the total doubles...
On my spreadsheet I have a column with "Test No."
I have a button that brings up a userform which allows me to input my test no which then populates the userform with the data from the spreadsheet for that particular test no.
At the moment it only allows me to lookup Numbers in my Test...
I've got two lists of names on two tabs.
One is from payroll and one is from the email system we use.
People have left but their email accounts have not been deleted.
I want to run a check and flag all the names that have email addresses but are not on the payroll so they can be removed...