Excel Forum
-
nested formula with 'or' statement Closed
Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in ...
-
Sumproduct gives me error Closed
Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it giv...
-
Find Text In one Cell, Add Different In Another Cell Closed
Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried every ...
-
Excel Closed
Hello, I want to transfer a single cell of information (which is a number) from an external excel sheet to another excel sheet. I dont need tables, l...
-
Moving columns based on text Closed
Suppose data is like this: 3 3 OPG 4 5 2 5 3 MCG 0 4 3 0 4 ELG 4 2 4 7 5 CTG 4 2 1 I want a macro ...
-
How to do recursive searches in Excel Closed
Hi, I have two worksheets. I need to be able to traverse a column in the first sheet and for each cell, compare it to a cell in the second sheet. If ...
-
cell auto filled with dots Solved/Closed
Hello, I sow it once but not sure where and can't work out how to do it. Basically, if I write things in excel, I need it to be auto filled with do...
-
tracking 3 columns of scores between 1-10: OSAT, Arrival, Staff Closed
I am excel illiterate so please forgive me... I need to create a formula that will go out and look for a set of initials, take the data associated ...
-
Automatically transfer data from one sheet to another Closed
Hello, I have a workbook in sheet1 details of materials issued to dealer for job work Sheet1 Columns: Dealer name, Date, Challan No, Item, Qty, etc ...
-
How to copy data from one excel table to other Closed
I have two sets of excel tables. The master table has got several columns with heads defined. Similarly, the row heads have also been defined. Now...
-
Compare text cells Closed
Hello, I need to compare text cell and return me column title- row 4 I have made this formulla =IF(B24=N5:N19,N4,IF(B24=O5:O19,O4,IF(B24=P5:P1...
-
error in date formate Closed
find attachment of date format issue .......how resole the error please let me know
-
Help: Macro compare worksheets and generate new with difference. Closed
Hello, I am trying to compare two worksheets Sheet1 and Sheet 2 in the same workbook. And after comparison it will be copied in Sheet3 with the d...
-
VlookUp Problem? Closed
I have 4 Column A,B,C,D A=date B=MarketValue C=Results D=Numbers when i use the vlookup formula in other sheet it not working =vlookup(A2,Shee...
-
Deleting rows with no data (in a range) Closed
Hello, I have a sheet that I have been working on..all working fine, however I have one last bit that I cant seem to get right. Worksheet - "Fr...
-
Total and Avg. data from another worksheet based on day of week Closed
I am doing tracking for my employer. I have a sheet (Sheet 1) that I input data for every day of that month(i.e. 1st-31st) in the adjacent column I li...
-
Insert date from one sheet to another Sheet ? Closed
Dear Sir I have Two Sheets one Name is FirmDate and Other Event i want i put one date in Event and 260 Dates FirmDate uper of Select date in i...
-
Excel how to question Closed
Hello, I did not intend to offend anyone when i originally posted this message, I am new to forums and was not aware of the policy. I do apologize. ...
-
Macro to rearrange data Closed
I would like to enter a data as shown in the sheet 1 pic below and want it to be stored as shown in sheet 2. Can someone share how to code using macr...
-
Conditional Formatting Special Closed
Hi, I'm trying to create a conditional formatting to highlight the column if the cell in row 4 ="S". I can do it one column at the time, like the ru...
-
if formula Closed
hi all Please help me with this. Any help will be appreciated. Thanks in advance. if date in column A which refers to a text in column B..(A1 date...
-
retrieved data automatically put into separate sheets as per th Closed
I have created a registration form using the survey form offered in skydrive excel. I would like to have the retrieved data automatically put into sep...
-
auto select print area and prints Closed
can anybody explain the Macro for auto select print area and print with a Print button in any cell i've a sheet with receipt. and i want to print r...
-
How to delete strings of words from a range of cells Solved/Closed
I have a list of website for which some start with www. and others start with http://. I have been trying to remove the "http://" from all the cells a...
-
Need Formula for automatic date update in same cell Solved/Closed
Hi all, I was wondering if anyone knew of a formula that would allow excel to change a date in a cell automatically once a certain date had passed?...
-
IF FORMULA Closed
What is the mistake in this formula ?? =IF((D10>(B10/2))&((F10)
-
How to show/hide excel worksheet using UserForm Closed
Hello, I have prepared one user form and given option button & submit button. I have 4 worksheet. My queries is.... 1. If I select Option 1...
-
using sheets in excel Closed
Hi, I am using excel 2007 and have a product database in sheet 1 with multiple columns. I want to take selected columns from this product datab...
-
Changing cell background color based on another cells background Closed
Hi guys. Quick question, is there anyway to change a cell background color based on another cell background being a particular color? I have a r...
-
match formula in excel Closed
to match data in one column to another and result from another column.
-
Excel Macro to search for specific cell and subtract value Closed
Good evening guys, My first question here. I'm being beaten by an Excel Macro, I've done some before but this appears to be beyond me. I'm tryin...
-
Wanted to insert column in excel sheet using macro. Closed
Sub test() Dim j As Integer, k As Integer j = Range("B1").End(xlToRight).Column 'j is the last column For k = j To 2 Step -1 Range(Cells(1, k), C...
-
Excel conditional formatting Closed
I have a worksheet that contains a row of payments per month....I want to include in a separate cell the amount of payments that are over $60 per mont...
-
Macro to move rows to a new location Closed
Hi, I was hoping for a macro that if in column "C" of an excel spreadsheet it has the number 8 or 9, the whole row gets moved 5 spaces below the the l...
-
Conditional format based on another cell on another page Closed
I have two databases. One is a list of parents and the other a list of students. The parents each have a unique 'Parent ID.' I need to evaluate each ...
-
Column change where pull values from according to the month Closed
Hi All, Please let me know if the below are possible and how: I have a workbook with multiple sheets named "SUMMARY" (Master sheet), "MAR", "APR...
-
Creating a Macro to Find Text and Then Merge Cells Solved/Closed
Hi- I need some help with creating a macro. I haven't been able to get it to record correctly and I am completely illiterate in Visual Basic. ...
-
convert numeric date into words Closed
hi want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or Twenty Tw...
-
Macro in Excel to copy and paste selected from one Sheet Closed
Hi I have an excel with couple of sheets. 1st sheet contains summarized data. Now I want to scatter the summarized data and copy the same data in t...
-
EDATE if then scenario Closed
I have a date column of original date of action. I have another column that has a formula to give me 6 months from that date (which is when additiona...
-
insert one new copy row Closed
i need help pleas :) i want to insert one new row every time Verifies the condition and also copy some cells from last row like if(y3="y",...
-
automatically insert the current date into one cell when "x" is Closed
I'm trying to create and IF formula. What I want it to do it automatically insert the current date into one cell when "x" is typed into a different ce...
-
To get a price from price list while making a purchase order Closed
Hi,I would like to know how to create a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pr...
-
Grading on excel Closed
i need some help to grade marks from a b c d e on excel 2010
-
Creating automated Attendance Closed
Herewith enclosed Attendance sheet which I am trying to figure out. Here are my few queries as of now: 1. Firstly I want to put restriction on RH (...
-
Use Conditional Formatting To Copy Entire Rows Closed
Hello, My name is Brandon I'm new to the forum and am thrilled to have found a community that specializes in excel. The current issue I'm having i...
-
To get a price from the price list while making a purchase order Closed
Hi,I would like to know how to reate a macro code I have two files one named Price list and other Purchase Order. Actually I wanted like this ,the pri...
-
Pivot Table Setup Closed
I need some simple pivot table help to get me past a stumbling point. The database I am working off of has the following columns. A: INVDATE B...
-
page set up Closed
Hi.. In Excel , I need to have at last paper from the sheet a different ( first row ) not matching the (repeated rows at the top of each paper from...
-
Macro to copy specific data from multi sheets based on criteria Closed
Hi, I am trying to copy specific cells from different sheets to master sheet under the following criteria: * Master sheet should be generated when...
