The discussions
Macro for copying data from different sheets
Solved/ClosedHello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated when ev...
If / and function and date range
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
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
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 ...
Trying to sum a column that contains various text
SolvedI'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
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 query urgent please.
SolvedHello, 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
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...
Excel list item automatically generates a new list
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...
Conditional formatting comparing dates
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...
Auto filter based on cell value
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
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.
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
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
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
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...
Want cells to show e.g. £100.00 when there is a value
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
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...
Vba to copy/paste rows by client name to different spreadsheet
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...
Data transffering
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
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...
Get max value
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...
Copying unlimited data from on excel to another excel..
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...
Setting due dates
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...
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
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
SolvedGreetings 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
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...
Vba to assign a counter to a constant
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
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
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 ...
Converting numbers to alpha
I need a simple way to convert a price to an alpha code, for instance Graystoke = 1,2,3,4,5,6,7,8,9,0 so if a price is $5.66 it appears as s.tt I n...
Percentage work
SolvedHi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here I at...
I need a macro please
Hello, I have 70,000 lines of data. I need to make 1400 files of 50 lines each from the original 70,000. So I'm hoping there is a macro that can p...
Recurring weekly date
Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL wit...
Text label and value if value in other worksheet is > 0
SolvedHello, can someone please help me with a formula for this. Text label and value, if value in other worksheet from 2 different cells is > 0, label...
Question with if function
Hello, I was wondering, if I have for example in C2, C3, C4 the next info: "Tableta Onda V989 Allwinner A80 Octa Core 9.7 Inch Sistem Operare A...
Take reference from previous sheet automatically
Hello, I make a payroll settlement sheet in excel every week. When i make next week sheet i copy previous sheet & start working on it. Sometimes i...
Excel - to generate unique id
SolvedHello, Good day. I would like to generate a unique ID from date and a customer number field. I tried this way but it was not working as desired. Bel...
Decrease the value first by 10% and then increase the value by 5
I want to decrease the value first by 10% and then increase the value by 5%. What is the formula in Ms excel.
I need a macro please
SolvedHello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B havin...
Excel using date range and formula on separate sheets
I'm creating a bank register with the dates in column A. Values are in columns C and D. The title of my first page is 'Register' What I'm trying ...
Copy daily cost entries into the particular ledgers
SolvedHello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: D...
Need msexcel 2007 formula
Hello, Masters of Excel. I need formula like H5+I5+J5+K5+L5+M5+N5-O5=P5. I need H5 to N5 add & subrtact O5 in P5. Hope i have detailed this brief. T...
Excel cell equal another cell only if its a certain percentage
Hello, I'm trying to have a cell equal another cell only if its a certain percentage (percentages are in another cell also, I tried "IFSUM" but its ...
Date entry
SolvedHello, i have an Excel sheet which my colleague should enter the date after he finished his job, for example:\today date is 2014/28/12 he shou...
How to lock or password protected specific cell in excel 2010
SolvedDear all: Hope you are fine. How can I Lock a specific cell of excel 2010 that any one can not change or input anything in that cell. Pleas...
Checking cell value against a range of numbers
Hello, I want to check a cell's value and if it falls in a particular range then I want to write "OK" in some other cell and if it falls out of sp...
Help with macro in excel
Hi I need some help in writing a macro for the below: 1. In sheet 1, I have column A with a list of items and many of them will be repetitive, ...
Date change in excel sheet
Hello, in excel sheet date come to 29/12/2014 now i wants date on 29/12/14. so help me how to change date format or use formula to change date fr...
