The discussions
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...
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...
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...
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...
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...
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...
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...
Excel macro to format report
SolvedHi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of submit..........
Need to write a macro to copy a row of information if true
SolvedHi, I have a workbook with several tabs and I want to first check if Column F on the first sheet contains 13 as the year (12/16/13 is the format) and...
Using a macro to copy & paste from one sheet to another.
SolvedHello, Hi Guy's I hope you can help, I am using two sheets. one is spread across different rows so when I click create list it copies everything ...
Excel formula numbers to dates
SolvedHi, I need an excel formula for changing numbers to dates. It is part of the Julian Calendar but backwards and one extra number. Ex. 273143 is 9/...
How to use releative refrences in conditional formating??
Solvedthe first picture is the formatting rule of C7 cell the second picture is the formatting rule of E7 cell which i copy from C7. as you c...
Conditional formatting based on another cell
SolvedHello, this is what I want: EXAMPLE: B3= Arash if B6=1 then B3 goes red if B6=2 then B3 Goes yellow and if B6=3 then B3 goes green i want to...
Conditional formatting based on another cell
Solvedi want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible...
Help me to add particular cells
SolvedHello, i want to sum particular cells when a number consists in a cell eg:- =IF($B$81:$BH$81=7=TRUE,SUM($B$77:$BH$77),0) it calculates a...
Macro/command button help
SolvedHello, I am in need of some help here and would greatly appreciate it. Here is what I am trying to accomplish. I have a basic excel file with two s...
Copy info from one excel sheet to another sheet
SolvedHello, I am respectfully asking for assistance on an issue i am having trying to write a macro for a form that i am currently working on. I have ...
What type does it want? (vba question)
SolvedHello, So I have a pull-down list in Excel 2003 that is an expanded version of this: 011 012 01T 111 If I type in the cell (rather than ...
Conditional formatting to hide 00:00 in column
SolvedHello, I would be very grateful if there is somebody who could help me find the solution to what is most likely a simple problem. I don't have a grea...
Help me on this formula to shorten
SolvedHello, i have 2 formulas tick mark automatically on worksheet.. please help me if further it can be shortened.. i want to know if J1 K1 L1 can sho...
Excel picture inserting macro help - urgent
Solved/ClosedDear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro which ta...
How to count different charecters
SolvedHello, Please help me to count different charecters like xpa, spa, spb xpb.. if any of this exist in the cell it should count. if xpa is in A1 spa...
How can i transfer data from one spread sheet to another?
SolvedHi, I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data ...
2 macros in one sheet targeting same cells
SolvedThis is probably a really 'newbie' question but in all honesty, I'm new to macros and need some assistance. I have a macro written to automatically...
Conditional formating to check text in another shell + numeric
SolvedI have some text in A column ( say xxx, yyy) and numeric value in Column B . Now i want to highlight the shell in column B with 4 condition . 1....
Help me to count 2 cells
Solvedhelo, please help me to count 2 celles A1 Is either 0 or 2, A2 is either 0 or 2 IF A1+A2=0 A3 should be 6, IF A1+A2=2 A3 Should be 3 if A1+A2...
Lock cells in excel
SolvedAfter setting up VB to lock cells in Excel I now need to lock additional cells. I currently have the following script (kindly given by rizvisa1) which...
Needs some help with a formula
SolvedHello, Configuration: Windows XP / Firefox 33.0 Okay, here is a problem I've been dealing with for over an hour now. This should be easy, but ...
Numbers & symbol ü (new challenge)
Solvedi need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1 Condition is H1 may contain any numbe...
Lock cell in excel worksheet with vb
SolvedI have an worksheet that I need to lock the cell based on the value of another cell. I have managed to create VB which will do this for one row but n...
Insert multi rows between existing data
Solved/ClosedHello, I am trying to create a macro that will insert a set amount of blank rows into a existing spreadsheet after each entry. The amount of rows ...
Copy and insert rows and number of times
Solved/ClosedHello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row. Example: Bef...
If function formula based on three possible values from adjacent
SolvedGood morning all, Excel 2007 - I need a formula based on the three possible values from an adjacent cell. 1st value: : if F5 is a date, a simpl...
Conditional formatting - highlight overdue dates
SolvedI am a beginner with conditional formatting and researching the net for an answer has left me more confused than when I began! I am working with Ex...
Auto filter depending on cell value
Solved/ClosedHello, I have data in a table, lets say the table is (A7:M200) and the Headings in this table is (A7:M7). Column 1 (A8:A200) is the accounts numbe...
How to find out the data in six month record
SolvedHello, I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has joined?...
Nested if then
SolvedHello, I would like to have the contents of b1 displayed in m2 if t2=1, the contents of b2 displayed in m2 if t2=2, the contents of c1 displayed in...
How to format cells based on the text in another cell
SolvedHelp me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to...
Insert/remove photos depending up on ref. cell value changing
SolvedHello, I designed a Student Profile in excel using LOOKUP function. In this profile, near the Student Name title I created one drop down list of stu...
Excel vba copy and paste loop with logic condition
SolvedHi, I am new to VBA and would appreciate some help with a problem I am trying to solve. I would like a macro that is able to copy information f...
Excel workbook with two sheets
SolvedHi, i have an Excel workbook with two sheets and when i enter data in sheet #1 it automatically goes to sheet # 2. How on earth can i stop this fro...
Auto transfer of a filtered item to a different sheet.
SolvedHello everyone, I would like to ask for some help regarding some EXEL problems. Example: I want some data from sheet1 E columns to transfer to...
Excel 2007 using vlookup function in vba
SolvedI have a list of name and employee number in sheet 1 in column a and b.. Then what i want is to by simply typing the employee number in sheet 2 column...
Format a cell with a comment based on a comment in another cell
SolvedHi, I need to format a cell with a comment based on a comment in another cell. So cell A1 might ask a question like is the window clean? B2 will...
Macro to copy paste without having all the source books opened
SolvedHello Kioskea users. I hope you're all doing great. Today I have a concern that I'm not able to figure out. Any help will be really appreciated. I...
How to convert date to word in excel
Solvedhow to convert Date to word in excel e.g. 05/01/1992 to change Five January, Ninteen Ninty two
Automatically transfer data from one sheet to another
Solved/ClosedHello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1 and ...
Calculate total total hours per client
SolvedHi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates ...
How to count date cells for monday of this week
SolvedHello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined...
