Excel Forum - solved topics
- Solved
-
DUE DATE REMINDER IN EXCEL TO NEW SHEET? Solved/Closed
Hello, I Have a problem in this code =INDEX(Master!$B$3:Master!$B$1067,MATCH(TODAY()+30,Master!$H$3:Master!$H$1067,0)) HERE I HAVE COLUM...
-
Regarding Pivot Solved/Closed
Hi I am doing Pivot for multplie data . In the Value field ( bottom right ) , I need SUM as default instead of count . I have to drag multiple ...
-
Find the first available (empty) cell on a worksheet. Solved/Closed
As a newbee to VBA, my boss has given me an impossible task ... Basically I need to be able to enter one cell worth of data from one sheet of a wor...
-
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 the v...
-
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 copy p...
-
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 17 ...
-
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 or ...
-
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 an ...
-
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 when ev...
-
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 ...
-
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 ...
-
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...
-
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 I at...
-
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, label...
-
Excel - To generate unique ID Solved
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. Bel...
-
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 havin...
-
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: D...
-
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 shou...
-
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. Pleas...
-
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 submit..........
-
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) and...
-
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 everything ...
-
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 is 9/...
-
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 you c...
-
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 want to...
-
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 possible...
-
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 calculates a...
-
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 two s...
-
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 have ...
-
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 than ...
-
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 grea...
-
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 sho...
-
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 which ta...
-
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 spa...
-
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 data ...
-
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 automatically...
-
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 wit...
-
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 . 1....
-
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 A1+A2...
-
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) which...
-
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, but ...
-
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 numbe...
-
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 but n...
-
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 rows ...
-
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 row. Example: Bef...
-
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 simpl...
-
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 with Ex...
-
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 numbe...
-
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 joined?...
-
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 displayed in...