Excel Forum
-
IF / AND function and Date range Closed
I am trying to create a spreadsheet that tracks when jobs commence and complete. I have been working with the IF and AND functions but can't quite see...
-
Excel 2007 : Conditional Formatting issue concerning colors Closed
Dears, I've successfully put a conditional format in my document, but I would like to have the whole row in color in stead of only 1 cell. Does ...
-
useing (='sheet'!cell) if the sheet name is depending on cell Closed
Hello, how to use (='sheetname'!targetcell) if the sheetname is in cell A2(sheet1) and the target is C3 ='sheet1'!C3 is working, but the sheet ...
-
Worksheet comparison Closed
I have two worksheets, each with the same 10 or so columns. In the newer one, a few rows have been added, a few deleted. In the many (1000 or so, henc...
-
Batch printing results Closed
We were provided with an Excel spreadsheet that will display data for a case number, which we are then instructed to print. This came with a list of 6...
-
Trying to sum a column that contains various text Solved/Closed
I'm a novice when it comes to excel and I'm hoping someone can help me with a formula. I'm trying to give a value to various text in columns and then ...
-
Trying to add a value if a test result is positive or negative Closed
Hello, I have been asked to build a spreadsheet to calculate patients follow up depending on their blood test result. I will only know if the ...
-
Excel 2007 : Change collor if date today is < given date -30days Closed
Dears, Does anyone know how I can highlight a date in red or green when a given date passes the last 30 days cf date today? ex 1 Today : 15/01/...
-
Excel Query Urgent Please. Solved/Closed
Hello, I have the below data in sheet 1, where as in column A its the activity and column b its the name of person who has done it. and the names ...
-
Is there a FORMULA for this issue? THANK YOU IN ADVANCE Closed
Hello, Please help, the issue goes like this, I want to find a NAME within a RANGE of CELLS and the result would be the LATEST DATE they have i...
-
Text cell text cell Closed
Hello, I need help with the following in Excel, I would like to have text then enter cell form another page then enter more text then another ce...
-
Excel list item automatically generates a new list Closed
Hi! Hoping someone can help ;D In Cell A1 there is a list called "clothing" (a drop down box). In the list you can choose "T-shirt" or "Sweats...
-
Autopopulate a templated spreadsheet with another spreadsheet Closed
Hello, We use Salesforce.com as our CRM and database, with regular use of reports. Naturally, we use those reports for sales and business developm...
-
Conditional Formatting comparing dates Closed
I have two columns, that each have dates in them. I want to take Column A, subtract 100 days, then compare it to Column B. If Column B is less than C...
-
moving complete lines Closed
i have a workbook with a number of sheets, i would like to have the data on a complete line from one worksheet move to another when i insert data in t...
-
How to copy data from multiple tabs in excel into one single tab Closed
Hi , I need help in excel macros where i need to copy selected data from different tabs in excel to another tab in the excel. What i want: I wan...
-
hot to read a cell value in remote file Closed
PLS. INFORM ME "HOW TO READ A CELL VALUE IN REMOTE FILE" REGARDS M.SELVAKUMARAN
-
Auto Filter Based On Cell Value Closed
Hello, I have a huge database and ever growing. I need to filter based on a cell value Summary!C2 this value is selected from a drop down list....
-
calculation of number of months Closed
Hello, number of months between 1/7/2013 and 26/1/2015 Configuration: Mac OS X Lion (10.7.5) / Chrome 39.0.2171.95
-
Excel file do not open normally. Closed
I have Office 2010 and Windows 7. I have one Excel file which has very abnormal behavior. First I opened it, drafted it a little, then closed. Next da...
-
trying to set up a payroll system for 1 or 2 casual employees Closed
I'm trying to set up a payroll system for 1 or 2 casual employees. Most forums recommend a manual system. Can excel add up a year to date column acros...
-
Copy select columns from a row given a criteria was met Closed
I have been working for quite a while on a spread sheet for a productivity tracker. I have tried to copy and past several codes and editing them, but ...
-
2 list matching Closed
i have 2 lists: LIST 1 A1 B1 sku1 4.50 sku2 5.00 sku3 6.50 sku4 2.25 sku5 1.25 need to enter/match these B1 values into a similar, but n...
-
Color scale Closed
Hi, i wanted to have 4 color scale using the following number with corresponding color on a separate cell. below is the example. I want the c...
-
IF functions for populating a cell if $ amount falls under Closed
Hello, I am trying to figure out the if function for populating a cell if $ amount falls under the month... If date is 2/6/15, then I want the $ to...
-
want cells to show e.g. £100.00 when there is a value Closed
Hello, I'm using Excel 2007 and I want cells to show e.g. £100.00 when there is a value but when there is no value I want the cell to show nothing...
-
Time differentials Closed
HELP!!! I have 4 columns and need to figure out the hour differentials Column A has a Date (1/3/15) Column B has a Time (9:00am) then Column...
-
Conditional formatting based on text list Closed
I use Excel 2007 on a Windows 7 laptop. I have a couple of hundred codes to enter into a spreadsheet every month. The codes are from 4 to 8 characters...
-
VBA to Copy/Paste Rows by Client Name to Different Spreadsheet Closed
Afternoon, I am new at VBA programming. I have tried sub copyrange and if/then with limited success. I have a master worksheet and individual work...
-
want to get some specific text from one sheet to another Closed
Hello I have some data in sheet 1 of 140 lines and have some name in coulmn b and have some reference data in column h And also have data in colu...
-
Data Transffering Closed
Good Morning. I am new to the forum thing so any help would be great. I am not sure if this is possible but I am looking to see if I can automatical...
-
copy values from a table to another tab Closed
Hello, I have an excel spreadsheet. How can I copy values from a table to another tab by placing an "x" in the right column. I only want th...
-
How To number Convert In to Word In Excel Closed
Hello, Configuration: Windows 8 / Chrome 37.0.2062.120 How To number Convert In to Word In Excel.... PlZ Say me Only totaly Formula .....
-
Drag Formula Horizontally with Macro Closed
Hello, Just new to Excel. I have a problem and request if anyone can help me out. I recorded a macro to paste column names in a formatted tab...
-
Date format Closed
Hello, Hello, I have changed the date format to dd/mm/yy. I tried to enter 9th of january as 09/01/15. whn i used filter option it showi...
-
Trying to have select info automatically copy to a new sheet Closed
Hello, I am reworking our cash sheet at my new job. I have been learning more about excel in the last few weeks than I have in many years prior. ...
-
get max value Closed
Col A Col B Col C Row 1 A A 110 Row 2 A A 200 Row 3 C C 199 Row 4 A A 92 Row 5 C C 85 Row 6 D D 172 Row 7 D D 150 Row 8 E E 177 Row 9 E E 199...
-
VBA, Move specific cells to another page Closed
Hi, I have one page for every month. On each page there will be button that runs the VBA code. The VBA code shall look for text in cells O7:037 in the...
-
copying unlimited data from on excel to another excel.. Closed
Hi All, I want to copy all the data from one excel sheet to another excel on load event (when I open) of destination excel. could you please hel...
-
Lists and If Formula Closed
Hi there, Bit of a strange request: I am attempting to create a costing list and require a series of lists on an If formula. Basically if B6 con...
-
Excel Formula for - Number to Text Closed
Hello, I want to know how to convert any number into Text format ( Indian Rs. INR) in Excel without using of coding (Macro). Its like the uses of ...
-
setting due dates Closed
I already have half of the formula needed.. d2=text, leave it blank =if(istext(D2),"","") I need a formula for this: d2=date, then add 14 day...
-
Looking at one cell if contains number returning text... Closed
Hello, I am trying to figure out a way to streamline a huge excel spreadsheet we have at work. I am trying to return text in a cell if there is...
-
Copy across conditional Formats Closed
Hello All ok I have 20 colomns of data the first 2 rows contain the upper and lower limits(all of which are different) the following 3 rows ...
-
Compare two sheets based on a common ID in both sheets in col A Solved/Closed
Greetings Kioskea team, First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solut...
-
Vlookup for mutiple shel Closed
Hi , I have requirement as below There is excel sheet 1 with column A with some text say xxx, yyy , xyz and coresponding numeric values in colum...
-
Transferring Data Closed
I am not sure if this is possible but I am looking to see if I can automatically get data I enter on a spreadsheet to transfer to the appropriate tab ...
-
VBA to assign a counter to a constant Closed
Can somebody provide me the VBA code for the following samples Before VBA code A B B A C A C A After VBA code 1A 1B 2B 2A 1C 3A 2C 4...
-
How to Convert DD/MM/YYYY to MM/DD/YYYY Closed
Hi All, Kindly help to convert DD/MM/YYYY to MM/DD/YYYY for the following examples. Thanks in advance, 19/08/2014 13/08/2014 13/08/2014 4/08...
-
copy and paste macro Closed
hello, I am new to the vba programming for excel 2010 but what I have been able to ascertain has helped me tremendously at work, however I am having ...
