The discussions
Comparing dates in multiple columns and using one that matches
SolvedHello, I have a table with multiple columns of date values and need to check whether a date in a certain column is less than that date and depende...
Auto populate into a different tab based on cell value
Hello, My job involves tracking several POs for several different vendors. I am looking to compile several sheets of data into one workbook with d...
Create & name worksheets from a list and copy data
SolvedHi Guys Really new to this and thanks to previous posts on here I have managed to create code to complete the first part of my jigsaw, just struggl...
Vba macros help
Hello, I have a need to create a macro that is beyond my knowledge. I recently started trying to learn how to write simple macros in order to simp...
Middle name extraction
Hi, I need to extract middle name from full name. for some case its working but in those names without middle name, it throws #VALUE! error. also ...
Formatting whilst using letters and numbers
I would like to conditionally format a spreadsheet based on grade progression, where the grade contains both a letter and number. The grades are n...
Conditional format make a row a color based on another cell
Hi, I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line. There is a column ...
How to insert columns until a cell condition is met
Hi everyone. I'm not very good in macro and hope that anyone could give me some pointers. I have a worksheet (ie. Project A) whereby it contains he...
Paste data from specified cells to another when just typing comp
Hello, Hello, I am trying to use macros to copy data from several cells into different cells in another sheet. My data is consisting of Organizati...
Macro to get random samples based on condition
How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.
If cell contains a word from a word bank, then return value
Hello, I need to be able to read a cell and see if it has any of the following word: John Jane Jake Jill Jack ect. Then return True on an...
Finding percentages
Hello, I'm not sure if i'm asking my question in the right place or not. I need to find percentage of attendance for a period of time. I have...
Cell referrence
Hello, How can we referrence a particular cell value in date formate in another cell which has a multiple number? Thanks
Lookup 2 cell headers one one sheet to find answer on another
Hello, I am trying to lookup the employee name and week # included on sheet A on sheet B in order to find the % of utilization during that week. ...
Need only date from text
Hello, how to get only date when a cell contains text. EX: MON 12/20/1968 12:30 . I want only the date 12/20/1968
Get value from cell to other sheet based on condtion
Hello, i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex: Cell A | Cell B ==============AB ...
Issue in excel
Hello, i am unable to change the date format in excel... actually it show 42625 but while "F2: 9/12/2016 can you please help me to resolve the iss...
Excel dates
ClosedHello, so how would july 7 1999 be written Configuration: Windows 7 / Chrome 53.0.2785.116
Excel 2010 doubt
ClosedHello, i have doubt in excel 2010 need to segregate the data after certain limits. Eg: fdkfkpfokdsl;kfdfkfdpifdflkd-k12383433326-05-2016 Descri...
Conditional formatting based on specific expiration date
Hello, I have a spreadsheet that tracks training my employees take. The cells include the dates (mm/dd/yyyy) that the courses were taken. Most of ...
Search then validate given values against given sheet.
I have two worksheets. One sheet is called "Valid" and contains values in the following cells: A1= 1234 A2= 123 A3= 12345 A4=123456 The other...
Formula question: "if" function with date
SolvedI am attempting to create a formula that will enter "Yes" into cell P1 if: the date in Cell E1 is before 07/31/16 AND the date in cell B1 is after 07/...
Highlight cells with text that match data validation menu
SolvedI see several similar questions on the forum but not quite the same and the answers don't seem to extend to my situation. I have an Excel sheet tha...
Change cell colour based on other cells text
Hello, I really need help on this one as I can't work it out. I need to change the colour of a cell if that cell and the previous 12 cells do not c...
Keep drop down/ data validation with macro
Hello, I searched around a lot and could not find an answer to this: I need to replace values in a cell with a macro while keeping the "Data Valida...
Command button to move data from one sheet to another
Hello, I have a report with a data sheet and a data removed sheet. The data sheet is from column A:AC. In column Q I have different statuses tha...
Formula to find out all the master id's
Hello, My first columns is a Master ID which is unique for every row. My 5th column is the item name where item name's do get repeated. I need a...
Copy potential data from one sheet to another if condition met
Hello all, thanks for taking the time to read this, I have a very specific formula request, or at least a request for direction on how to write/lea...
Need to match two values and return another value
I have two spreadsheets in which I need to match two values and return another value. So, in my case, if Column C and Row 24 match (in spreadsheet A) ...
Compare data and summarize on seperate sheet
Hello, Each month I download a 1,000+ line of Part Numbers with inventory qty and value to an excel tab. I want to compare the part numbers to se...
Search/transfer patient data
Hello, If anyone could help me, it would be greatly appreciated. Ok I have a spreadsheet with different patient names. If they are inpatient then ...
If then formula question
Hello, If you have a value in cell a that equal 42:15 (42 hrs and 15 min) and in another cell you want it to look at that cell, determine if the hou...
Pop up reminder vba
hello everyone, i have very little knowledge about excel vba, actually i am making an excel file. i want it have pop...
Validation code
Hello, Why can't I get a validation code? Configuration: iPhone / Safari 4.0
Another copy from master to specific sheets
Hello everyone, First post here and I am not, by any means, an excel expert (my husband thinks he is, which is why I'm here, lol). So here is my qu...
Macro for looping charting data keyed from two columns
Hello and thank you anyone for reading this. I have a quandary that is beyond my VB skills and am looking for any help possible. I need to find a ...
Macro to create new workbook and copy data
SolvedHello I am looking for macro to copy rows based on partial cell content of a column. I have an excel spreadsheet called "arc.xlsx" from which I wou...
Macro to move data between sheets on condition
Hello, I am a beginner to using Macros in excel. I understand there are lots of things on here, and the internet in general, telling you how to cre...
Excel date formula (if)
Hello, I'm in need of some assistance with an excel date formula. I'm need to look at 2 cells in the same row which contain dates or may be NULL...
Copying data
Hello, I presently have stock sheets with details of suppliers, items, quantities held-in stock and on display, price, etc. Whenever I reduce the q...
Short cut between 2 sheet
can someone show me a short cut how to transfer a date or number from sheet 1 to sheet 2.
Chart out a grid using excel
How can I build a grid using an existing excel sheet that already has the cell references and the name. This document has four groups each containing ...
Conditional formating
i have a row of initials: MM MM MM MM LL LL LL BB XX XX MM CC CC CC, each pair is a column these correspond to booking dates, so if the initial next...
To get notification in outlook from excel
hi iam using excel for my work and i am trying to manage due dates ie if a due date is arrived it shoud be be notified in outlook as notification with...
Conditional formatting between 2 different columns
Hello, If someone can please help me. I have 2 columns. One column needs to be formatted w/ a specific color within a range of numbers depending o...
Compare values in two columns and return the value from third
SolvedHello, I've a table containing four columns. If the values in the first two columns match to particular value (eg. A1="xxxx" and B1="yyy"), I need...
Place specfic text in cell based on text in an adjacent cell
SolvedHello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that cell, I ...
Change format of a cell when another cell is not null
How do I highlight a cell or row when another cell contains anything? Thanks!
Conditional formating
Hello, I'm trying to make multiple cells turn red if a single cell has a certain value. So for example is B3 says "abc" cells B3:F21 should turn r...
Find duplicate rows and copy content of one cell to new sheet
Hello, I'm totally new to macros and excel. I have an excel spreadsheet with huge data in it (over 9lakh rows). There are many entries that are ex...
