Excel Forum
-
Reminder in MS Excel 2003 [Closed]
Hello, I would like to add reminder which displays reminder message once it opens. Onething I dont know the VB or something extra programming soft...
-
excel i want to sum only numeric values except alphabetic values [Solved/Closed]
Hello, in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total ...
-
change cell color based on input in a range of cells [Solved/Closed]
Hello everyone, I have formatted a cell based on a specific text entered in one cell. Example, A1 will turn green if I write "yes" on B2, using cond...
-
Nested if's [Solved/Closed]
Hello, I would appreciate if somebody could help me in solving this problem. I am trying to make exel decide in an scheduled soccer games which team ...
-
Excel date format won't change [Solved/Closed]
If I enter a date into a cell in my Excel spreadsheet using the shortcut (CTRL+;), I can no longer change the formatting (right-click, format cell). T...
-
ActiveChart.SeriesCollection [Closed]
Hi, Guys! Can anyone help me with this code below. I want to make the range of the ActiveChart.SeriesCollection to be from $C$3 to my last cell wit...
-
Pop up reminder [Closed]
Hello, 5 day Pop up reminder for excel in vba that runs in excel 2007 I'm new to this hope you can help Thanks djandpj Configuration: Windo...
-
Macro to merge rows but keep column data [Closed]
Hello, I am new to this and I have seen there a number of questins regarding merging rows in Excel. I hope someone can help with this one: I h...
-
Macro - Predefine column ID [Closed]
Hi There, in order to add more flexiblity, I want to predefine the column criteria/search column ID at frontend ie in excel sheet and use it at ba...
-
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 ...
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- How to Create a Gmail Account
- How to Fix a Blurry Snapchat Video
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Install a VPN