Excel Forum
-
excel,problem with if function [Solved/Closed]
Hello, i am working with excell with follwing formula- =IF(H33>=75,"A",IF(H33>=60,"B",IF(H33>=45,"C",IF(H33>=33,"D",IF(H33>=0,"E",IF(H33=AB,"E"...
-
Excel Drop Down / Formula Help [Closed]
Hey Everyone, I am looking for some help with this formula. I have a spread sheet that has 11 categories, all are sorted into a dropdown menu in...
-
convert rupees to spell value as text [Closed]
Hello, I want to convert rupees to spell value as text.please tel me what is the programs. like e.g 2*2=4.then i need the 4=four.or 2020= two t...
-
excel i want to count number of persons in given3diff.conditions [Closed]
I am making result sheet where 60 students obtained different marks out of 500 marks now i want to count the number of students in 3 different cells w...
-
copy linked fields in excel spreadsheets [Closed]
Hello, I have two excel spreadsheets, that have invoice number as a common field. In sheet A, the the invoice number might repeat in 5-10 rows, on...
-
VBA Code: Copying rows from multiple sheets [Closed]
Hello, I'm trying to use VBA to copy rows that satisfy a certain 'If-Then' statement from multiple sheets in Excel onto one sheet. All of the sheets...
-
excel.i want to count the number of persons in given 3 condition [Closed]
Hello, i am making result sheet where 60 students obtained different marks out of 500 marks now i want to count the number of students in 3 differe...
-
how to copy/paste a file from external file into a worksheet.. [Closed]
I have a problem of copying excel into new file. I have a browser which takes an excel file and puts it into a text-box. Then I have a second but...
-
Comparing two columns of names in Excel [Closed]
Hello, I need some help with an Excel formula. I have a column of user names and a column of usernames intermixed with non-user names. I would lik...
-
Mirroring data from multiple sheets into one summary sheet [Closed]
Hello, I have as sheets with data in them, I would like to create a summary sheet in the same workbook such that whenever any of the sheets are upda...
-
Highlight Cells Based on Drop Down List Selection [Solved/Closed]
Good day, I would like to have a row highlighted in color based on the drop down list selection. I have inserted the following in Worksheet but I e...
-
Excel 2003 days before a certain date [Solved/Closed]
Hello, I am making a spreadsheet which has, for example, a given date of 1/1/2012. When I enter that number into cells A1, I want it to return ...
-
Excel 2010 formating / sumation issues [Closed]
Hi I've got an Excel 2010 issue and I can't seem to find the answer any where. I'm generating a spread sheet from a C# application which displays...
-
Insert Line Number for Two Columns Document [Solved/Closed]
Hello, I have a problem to do a process of line numbering in MS Office 2007 Word Document. I have a document, it has 2 columns and I have to inser...
-
Copy data to master sheet, when >0 [Closed]
Hello, Is there anyone who can help me with this? I cannot for the life of me figure this out and need this spreadsheet working asap for my boss. ...
-
Excel Macro to Create a Workbook for Each Col [Closed]
Hello, I need help I know next to nothing about macros but I'm am working on a project that comes around every quarter and I know that there has t...
-
how to supplement this macro? [Closed]
Hi Guys, I was advised the below macro which works wonderfully, searches for the desired cells from one column and copies them to where I want. I w...
-
Create drop down list on certain cells [Solved/Closed]
Good day, I wanted to create a drop down list from data in Sheet2. I have tried the following codes but the outcome seems to be incorrect. Instead...
-
Date format in excel. [Closed]
Hello again, Is there a way to make excel read fields left padded with a 0. For example I have a program that only reads date format like th...
-
Macro for finding dates [Solved/Closed]
Hi guys, Is there a macro that would give me the the cells in a column in which there are dates between 2012 and 2013. It can be easily filtered b...
-
EXCEL & Power point MACROS [Closed]
Hello, I am wanting to create a macro, if possible, that will pull only certain data from one worksheet that i get daily and paste that data on an...
-
having trouble with macros [Closed]
Hello, I need you help please, I want to write the macros something like this: if x = 1(number of month) and y = 1 then z = 31(number of the ...
-
Macro To Copy Data [Solved/Closed]
Hello, I have two excel sheet with three column on each sheet Sheet 1 Sr.NO Code Name 1 1256 2 1256 3 1258 4 1258 5 1259 6 1259 7...
-
How to build a macro that does this... [Solved/Closed]
Hello guys, I would like to build a sheet that contains several names and infomation pertaining to each name. The first tab would be the search in...
-
Macro to compare worksheets, highlight change [Closed]
Hello, I'm trying to create a macro that compares two excel worksheets and highlights the rows that are different. Basically, there is a sheet w...
-
auto extend of range in excel macro [Closed]
Hello, friends I am working on data I have a formula in range w1:aa1 and I want to copy paste that formula in range (column 0:Column S) till the ...
-
Vba code [Closed]
Hello, I need to know how to change normal path to a server path. Eg c:/home/my.xls To serverpath/home/my.xls Any idea how I can do this ...
-
Separating items from columns [Solved/Closed]
Hello guys, Could you please help with this... Is it possible to do the following in excel: I have similar cells to this in one column: Ford v-36...
-
Sumif Excel Function - multiple conditions [Closed]
Hello, I have a list of job titles in column A with their corresponding headcount amount in column B. Is there a sumif formula that will sum the t...
-
VBA to Copy data on date [Closed]
Hello, Team please help me with the below situation. I have 15 workbooks, every day i capture data in sheet1, it has 8 columns, with date in 7t...
-
A Macro to move data from rows to columns [Solved/Closed]
Hello, I have data in a single column and would like to copy it into a rows for every x rows, for example; The column of data varies in the amoun...
-
Macro question [Closed]
Hello, I'm new to the forums and was wondering if someone could help me with creating a macro in MS word. I've had a little experience with macro...
-
How to match 2 row of data in excel ? [Solved/Closed]
Hello, brothers & sisters I have 2 columns of companies name say (column a=38900),(column b=1000) so how can i use a formula to do a match by thei...
-
Excel - How to repeat multiple functions [Closed]
Hello, I'm trying to set up a spread sheet in excel. Following is an example. A1 is say 500 B1 is say 50 and is a number from a IRS table t...
-
Excel Data Merge [Closed]
Hello, I have two excel sheets that are similar. Sheet one has a master list of contractors that are active and sheet two has another list of contr...
-
large col. based data to be changed to rows [Closed]
Hello, I have a large excel 2010 based data file sent by my retail partner. The first 5 columns have the list of my SKUs being sold by them, ...
-
[Excel] Macro to add prefix to column [Closed]
Hi, I recorded the following macro to add a thorn symbol before and after each record in a table. I can't figure out how to edit the macro so that...
-
How to handle linked cells? [Closed]
Hello, I am trying to get this formula to work: =IF(T8=0,"100% with PO",T8&" days, NET") T8 is linked to another table and contains the followi...
-
Match data from Master Worksheet [Closed]
Hello, i have two worksheets A & B with different fields but one field is common in both worksheets. I want to get some field from sheet B. Fiel...
-
Excel row to colum [Closed]
Hello, i would like a little bit help. i want from this: data1 data2 data3 a 120 20120903 b 270 20120903 c ...
-
excell find in a cell some text [Closed]
Hello, I am trying to find in a cell some text. I would want for example in D1 to see if it had: Low Low, if so put a 1 in the E1; High High, put ...
-
Embed Macro [Closed]
Hello, I hope this isn't too much of a nasty one for Friday afternoon! Any assistance much appreciated. Is it possible to run a macro inside of ...
-
Excel, comparing two sets of two rows [Solved/Closed]
Hello, I know the title may be a little confusing, and I apologize for that, but I really did not know how to phrase it. What I have is two Excel...
-
Excel formula which calculates start date [Closed]
Hello, I would like to create a calendar tool that will generate a start date from a set end date that excludes weekends based on processing and t...
-
Text in Macro [Closed]
Hello, I'm new to writing macros and wonder if anyone can help me with a couple of areas I'm stumbling on? Firstly, let me say that I am wr...
-
Conditional Formatting Excel 2007 [Closed]
Hello, I am trying to create a rule that when "yes" is selected in the drop down menu in cell F3 cells from A35:D39 are filled yellow, and if "no"...
-
setting up Excel to pick numbers for my list [Closed]
Hello, I would like to use Excel program to pick 6 numbers for a list i have. can ths be done? Thanks Configuration: Windows Vista Internet Explo...
-
Open Excel document from desktop [Closed]
Hello, When I right click the mouse on the desktop, I am unable to open the excel document from the shortcut menu. The excel document does not sh...
-
Macro to create files based on the contents [Closed]
Hello, I want to create a macro which creates files based on contents in column AJ. I want the macro to copy the data from original sheet to the re...
-
Excel Date Format [Closed]
Hello, I receive a report that has the date displayed as just numbers. Example: 20120131 How can I change the data to read: 01/31/2012 ...
