Forum
- Solved
-
Excel Macro's copy data from one sheet to another [Solved/Closed]
Hey Everyone ok, so, I have a document with multiple sheets one of the sheets is a reporting sheet what i am trying to accomplish with not...
-
Get a value from Col A based on the max value found in Col B [Solved/Closed]
Hello, Get a value from Column A based on the max value found in Column B display in Column C. I need to get value Jill in Column...
-
Comparing dates in multiple columns and using one that matches [Solved/Closed]
Hello, 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...
-
Macro to insert a number into cell A11 for 180+ excel files? [Solved/Closed]
I used the macro below to merge a bunch of files but it cut off the last row of data. It looks for the first A cell with nothing in it to end it...
-
Create & name worksheets from a list and copy data [Solved/Closed]
Hi 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...
-
Formula Question: "IF" function with date [Solved/Closed]
I 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...
-
Highlight cells with Text that match data validation menu [Solved/Closed]
I 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...
-
macro to create new workbook and copy data [Solved/Closed]
Hello 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...
-
Compare values in two columns and return the value from third [Solved/Closed]
Hello, 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...
-
Place specfic text in cell based on text in an adjacent cell [Solved/Closed]
Hello Folks, Per the preface, I have a cell that has validation rules of "Concur, Non-concur". If the user selects "Non-concur" for that...
-
Adding points from one sheet to another [Solved/Closed]
Hello, I'm trying to record points that students accumulate in a club. In a GoogleForm, I check off the students (Estudiantes) that earned...
-
trying to create an order sheet [Solved/Closed]
Hello, 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...
-
Exporting data [Solved/Closed]
Hi 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...
-
Conditional format to highlight cell based on date [Solved/Closed]
hi 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...
-
VBA search column for matching string [Solved/Closed]
I 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...
-
negative cells [Solved/Closed]
Hello, 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...
-
calculate no of days left from today to a future specified date [Solved/Closed]
Hello, 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 [Solved/Closed]
Hello 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...
-
need help to macro my invoice number [Solved/Closed]
Hello, 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...
-
search value error [Solved/Closed]
HI, 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...
-
Nested If Statement not working [Solved/Closed]
Hello, I am trying to use nested excel IF(And) formula. here's my logic table If O4=Planned,TRUE, FALSE TRUE...
-
Macro - pictures to excel acc to name [Solved/Closed]
Hi, 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...
-
Conditional formatting based on two cells (date and comment) [Solved/Closed]
Hi 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...
-
If multiple cells contain value then add value [Solved/Closed]
Trying 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...
-
odd and even cells [Solved/Closed]
Hello, 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....
-
HELPP!! Simple MACRO help! [Solved/Closed]
Hello, 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...
-
IF formula help [Solved/Closed]
Hello, 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 [Solved/Closed]
Hey, having a bit of trouble, appreciate any help. I am trying to create a payback calculator where you input: Initial...
-
Conditional Formatting Based on Data in another Cell [Solved/Closed]
Hello, I would appreciate any help you can offer on the following scenario. I tried conditional formatting, however, the columns in Row E either...
-
Excel has file big size [Solved/Closed]
Hello, 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...
-
Conditional Formating: formula cell text change color [Solved/Closed]
Hello, 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...
-
Conditional Formatting when a cell says "NO" [Solved/Closed]
Hello, 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...
-
If a cell has a certain value after certain date, color the row [Solved/Closed]
Hello, I'm working with deadlines, and projects need to progress from one stage to another by specific dates. I have 3 deadlines: A:...
-
Matching 2 values from one spreadsheet [Solved/Closed]
Hello, I have 2 spreadsheets.. first has 3 columns id, date, time value second volume with id header across of date would like to...
-
How to count how many times a number appears in a spreadsheet? [Solved/Closed]
Hey~ 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...
-
comparing the two names respective of Upper & Lowercases letters [Solved/Closed]
Hello, 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...
-
comparing 2 columns from 2 different spreadsheets [Solved/Closed]
Hello, Here is what i am trying to do. Spreadsheet 1 column B has customer numbers Spreadsheet 2 column A also has customer...
-
compare two columns input value from another [Solved/Closed]
Hello, 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...
-
Highlight cell if another cell contains any text [Solved/Closed]
Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found...
-
EXCEL VBA: Application.FileSearch Error in Running Excel 2013 [Solved/Closed]
Hello everyone, I encountered error "Object doesn't support this action" when i run the macro program after upgrade of excel (from 2003 to...
-
Roster Management Spread Sheet. [Solved/Closed]
Hello, 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...
-
If certain 'type' is in col. K have whole row copy to new sheet [Solved/Closed]
Hello, 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...
-
Finding MAX value with criteria list [Solved/Closed]
Hello 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....
-
Convert Single Column to Rows, into Matching Rows [Solved/Closed]
Hi, 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...
-
Need help with counting value formula [Solved/Closed]
Hello, 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...
-
Extract data from one sheet to another [Solved/Closed]
Hello, 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...
-
Copy a row from one worksheet to another, based on criteria [Solved/Closed]
Hi 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...
-
Write text in adjacent cells if one cell value is ___? [Solved/Closed]
Hello, 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...
-
Help! Need to copy only some columns in rows that have X condtn [Solved/Closed]
OK, 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...
-
Use of '@' in formulae [Solved/Closed]
Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the...
DON'T MISS
- Reverse Image Search with Google
- GTA Vice City Cheat Codes
- No Sound from Headphone Jack
- Get the Transcript of a YouTube Video
- Facebook Confirmation Code Text Not Received
- Credit Score
- How to Download Instagram Videos
- How to Block Private Numbers
- Sign Up for a Free Netflix Trial
- Writing Professional Emails in English
-
Google Play Store (APK)
-
Minecraft
-
xVideoServiceThief
-
TubeMate YouTube Downloader for Android
-
Instagram for PC
-
Microsoft Office 2010
-
Truecaller: Caller ID & Dialer for Android
-
Adobe Flash Player
-
Facebook Lite for Android
-
YouTube Downloader HD