The discussions
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...
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...
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 ...
Adding points from one sheet to another
SolvedHello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned x po...
Trying to create an order sheet
SolvedHello, I am trying to create an order sheet in Excel. I have an inventory list with various information. One of the cells is where I input how may o...
Exporting data
SolvedHi am so excited to join this forum!!! Pls I need help. I have 14 sheets on a workbook (for 14 of the company's locations in Canada). The data c...
Conditional format to highlight cell based on date
Solvedhi guys! I need some help. I'm creating a spreadsheet to show when car MOT expires. I have a column (F) which has MOT expiry dates in. I h...
Vba search column for matching string
SolvedI am trying to write a script in VBA for excel. For an entire column of data in sheet 2, for each individual cell in a column, I need to search a c...
Negative cells
SolvedHello, Please would someone help me with what I think is a simple problem. I have a range of cells which decrease in value and some become positive n...
Calculate no of days left from today to a future specified date
SolvedHello, How to calculate no of days left from today to a future specified date Configuration: Windows 7 / Chrome 52.0.2743.116
Compare columns and create list of duplicates
SolvedHello I am a complete newbie when it comes to VBA code but I tried to set up a macro with examples I found online. Let me explain my needs. I have a ...
Need help to macro my invoice number
SolvedHello, I wish to increment my invoice number everytime I open my invoice....format is 1-2015-001 and increment by one 1-2015-002 should be the next...
Search value error
SolvedHI, The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank i...
Nested if statement not working
SolvedHello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE =IF(AND(I6>=C7,I6=F7,I6=C7,I6=F7,I...
Macro - pictures to excel acc to name
SolvedHi, I have an issue - I checked all forums I could, but with office 2013 and changed excel functions, I got lost. My excel has pictures names in...
Conditional formatting based on two cells (date and comment)
SolvedHi guys and dolls, I am hoping one of you clever people might be able to help me... I am trying to highlight a cell when 1. a date has passed ...
If multiple cells contain value then add value
SolvedTrying to think of the best way to sort this problem! . I have a spreadsheet with a list of customers that have purchased a vehicle. Along side in...
Odd and even cells
SolvedHello, I am trying to link cell C1 to cell F6. But if cell C1 is an even number I need it to add 1 to that number ( cell C1) and put it into F6. If ...
Helpp!! simple macro help!
Solved/ClosedHello, I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into a...
If formula help
SolvedHello, I am needing a formula like this =IF(OR(B4="apple",B4="Banana",B4="carrot"),"yes","no") but if the cell B4 is blank. I need a blank " ". ...
Creating a payback calculator with rate change
SolvedHey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial Investment Rebates Annual...
Conditional formatting based on data in another cell
SolvedHello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either all...
Excel has file big size
SolvedHello, Hello, I have an .xls files I open with Excel 2007 every day. It is approximately 200 rows x 60 columns. Each day we create a copy of th...
Conditional formating: formula cell text change color
SolvedHello, How do I get Text in a Cell to Change from Black to White, based on data? The cell already contains a formula to extract data from elsew...
Conditional formatting when a cell says "no"
SolvedHello, I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. W...
If a cell has a certain value after certain date, color the row
SolvedHello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A: Create BR...
Matching 2 values from one spreadsheet
SolvedHello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to populat...
How to count how many times a number appears in a spreadsheet?
SolvedHey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadshe...
Comparing the two names respective of upper & lowercases letters
SolvedHello, here am trying to know something about the compare of 2 names in excel below is my format Http:CCM_net_C2E http:cCM_Net_c2E i have ...
Comparing 2 columns from 2 different spreadsheets
SolvedHello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer numbers Spreadsheet 2...
Compare two columns input value from another
SolvedHello, Here is what I am trying to do, can some one please help me. In my Excel Workbook I have 2 spreadsheets. The first spreadsheet we will ca...
Highlight cell if another cell contains any text
SolvedHello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my an...
Excel vba: application.filesearch error in running excel 2013
SolvedHello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to 2007).Up...
Copy paste special into last row of another worksheet
SolvedHello, Thank you for taking your time to read my questions. My question is the following any form of help will be greatly appreciated. I am ...
Roster management spread sheet.
SolvedHello, Can anyone help with a spreadsheet to manage fatigue management. I have a work project where I need 20 people and for both day and night ...
If certain 'type' is in col. k have whole row copy to new sheet
SolvedHello, I am wondering if it is possible to have a whole row copy to a designated sheet based off of the value in a column. So for example if my ro...
Finding max value with criteria list
SolvedHello Chaps I don't often ask for help here but this one has stumped me. For a dashboard of sorts... I have a list of values in column S. E...
Convert single column to rows, into matching rows
SolvedHi, I would really appreciate any help with an issue I currently have. I have a file which downloads as ASCII (text), and when opened in excel give...
Need help with counting value formula
SolvedHello, I am brand new. I am trying to figure out a score based counting formula. I have columns with Name, Status, Rank and Value I want the v...
Extract data from one sheet to another
SolvedHello, I have two sheets of data with almost same columns but sheet 2 has an extra column. How to match the data of sheet 2 with the data in sheet 1...
Copy a row from one worksheet to another, based on criteria
SolvedHi Im a new user and im trying to make a roster sheet and really need some help any help is absolutely appreciated. I have some good formulas alread...
Write text in adjacent cells if one cell value is ___?
SolvedHello, My knowledge of excel is very basic, but I am interested to know if I can find an easier way to enter information. I'm a tea manufacture...
Help! need to copy only some columns in rows that have x condtn
SolvedOK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that thes...
Use of '@' in formulae
SolvedHi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Reta...
Conditional formating question
SolvedHi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...
If formula with dates
SolvedHi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...
Creating master spreadsheet for mailing information
SolvedHi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...
Macro only for alphabetic sheets
SolvedHello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...
Excel vba to open a eula script when opening a spesific workbook
SolvedHi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...
