Excel Forum
- Solved
-
Lookup problem. [Solved/Closed]
I have a column of 20 dates in col. B spaced by 2 or 3 weeks, and a number beside each one in col. C. In cell C24 I need a formula that returns...
-
Copy Paste Data in Same column for multiple time [Solved/Closed]
Hello, i need following manipulation.... Data Before Column "A" 123456 123456 123456 123456 123456 ( After )Column "A" (After...
-
Replacing Duplicates [Solved/Closed]
My Excel spreadsheet is set out as follows: A B C D E F 1 2 14 0 14 14 2 1 13 0 13 13 3 4 4 1 4 4 4 3 3 1 3 ...
-
Excel - Macro to highlight Rows with Duplicate values in a cell [Solved/Closed]
Geetings, Kindly help us in creating a macro that highlight rows based on duplicate values in a cell [this cell may contain Alphabets, Numbers...
-
IF function with DATE in Excel [Solved/Closed]
Hi, hope someone can assit. I need to create a sheet where I must take the current date and add a fulle week or two weeks to the date by selecting...
-
Macro for copying data from different sheets [Solved/Closed]
Hello, I am trying to copy data from different sheets to master sheet under the following criteria 1. Master sheet should be generated...
-
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...
-
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...
-
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...
-
Percentage Work [Solved/Closed]
Hi all, Good day!! Need help in Excel formulas. I'm creating a workbook to counting a value in multi percentage and multi level. Here...
-
Text label and value if value in other worksheet is > 0 [Solved/Closed]
Hello, 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,...
-
Excel - To generate unique ID [Solved/Closed]
Hello, 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....
-
I need a macro please [Solved/Closed]
Hello, 1 spreadsheet has 15 columns of data with column A having the unique identifier 2 spreadsheet has 37 columns of data with column B...
-
Copy daily cost entries into the particular ledgers [Solved/Closed]
Hello, I want to copy the daily cost entires into the particular ledgers, which i put in different sheets. Ex: I have the following data: ...
-
date Entry [Solved/Closed]
Hello, 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...
-
How to Lock or password protected specific cell in excel 2010 [Solved/Closed]
Dear 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. ...
-
Excel macro to format report [Solved/Closed]
Hi everyone, I am new to this forum..........so new I've already typed my question, then clicked "ask your question" again instead of...
-
Need to write a macro to copy a row of information if true [Solved/Closed]
Hi, 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)...
-
Using a Macro to copy & Paste from one sheet to another. [Solved/Closed]
Hello, 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...
-
excel formula numbers to dates [Solved/Closed]
Hi, 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...
-
how to use releative refrences in conditional formating?? [Solved/Closed]
the 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...
-
Conditional formatting based on another cell [Solved/Closed]
Hello, 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...
-
Conditional formatting based on another cell [Solved/Closed]
i 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...
-
help me to add particular cells [Solved/Closed]
Hello, 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...
-
Macro/command button help [Solved/Closed]
Hello, 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...
-
Copy info from one excel sheet to another sheet [Solved/Closed]
Hello, 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...
-
What Type does it want? (VBA question) [Solved/Closed]
Hello, 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...
-
Conditional Formatting to hide 00:00 in column [Solved/Closed]
Hello, 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...
-
help me on this formula to shorten [Solved/Closed]
Hello, 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...
-
Excel Picture Inserting Macro Help - Urgent [Solved/Closed]
Dear Rizvisa, please consider this little urgent and be kind to help me please I m trying to insert picture in excel column using macro...
-
How to count different charecters [Solved/Closed]
Hello, 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...
-
How can I transfer data from one spread sheet to another? [Solved/Closed]
Hi, 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...
-
2 macros in one sheet targeting same cells [Solved/Closed]
This 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...
-
How can we find data in different Excel sheets by VBA? [Solved/Closed]
Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table...
-
Conditional formating to check text in another shell + numeric [Solved/Closed]
I 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 ...
-
help me to count 2 cells [Solved/Closed]
helo, 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...
-
lock cells in Excel [Solved/Closed]
After 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)...
-
Needs some help with a formula [Solved/Closed]
Hello, 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,...
-
Numbers & Symbol ü (New Challenge) [Solved/Closed]
i 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...
-
Lock cell in Excel worksheet with VB [Solved/Closed]
I 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...
-
Insert Multi Rows Between Existing Data [Solved/Closed]
Hello, 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...
-
Copy and insert rows and number of times [Solved/Closed]
Hello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding...
-
IF function formula based on three possible values from adjacent [Solved/Closed]
Good 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...
-
Conditional Formatting - highlight overdue dates [Solved/Closed]
I 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...
-
Auto Filter depending on Cell Value [Solved/Closed]
Hello, 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...
-
How to find out the data in six month record [Solved/Closed]
Hello, 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...
-
Nested if then [Solved/Closed]
Hello, 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...
-
How to format cells based on the text in another cell [Solved/Closed]
Help me! I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain...
-
Insert/Remove photos depending up on ref. cell value changing [Solved/Closed]
Hello, 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...
-
Excel VBA copy and paste loop with logic condition [Solved/Closed]
Hi, 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...
