Excel Forum
-
Excel 2010; Need help w/If, Then formula [Closed]
I need a formula that if there are duplicate values in column A, then it will sum the values in column D for the rows with duplicate values in column ...
-
Autofilter range by selecting cell from a column in that range [Closed]
Hello, I have a 6 column overview with Description rule sets for Titles and Subtitles of Product groups. Each set consists of two rows: The desc...
-
Transfering data from one sheet to another, but not duplicating. [Closed]
Good day all. Checking to see if anyone could help out, as iam very new to the excel world. I have a sheet that I am transferring data to another s...
-
Macros for formatting a data dump [Closed]
Hi All, I am new to macros and was looking if some 1 could help in coding a macros for formatting of the data. Below are the issues/Steps 1. Th...
-
Excel: Unique count of values in one column conditional 2nd colu [Closed]
Hello, Column A Column B: WEST-WARD,INC. 00015 WEST-WARD,INC. 00015 HOSPIRA 00016 ROXANE LABS. 00017 GLOBAL P...
-
Conditional Formatting in Excel [Closed]
I have built a GANTT chart using Excel, and have been able to create the formulae in the task bar cells that allows the proper display of those bars i...
-
Error when creating mailmessage [Solved/Closed]
Hello, Using Excel and Outlook 2007 I want to create an emailmessage with a Macro. But I am running into an error I can not find any "comprehensi...
-
Calculating days between clinic visits [Closed]
Hello, I have a database with two columns, column A is date of clinic visit, and column B is patient name. I would like to be able to calculate th...
-
Copy data to another workbook and auto fill [Closed]
Hello, First, I Have excel data base that he have information in 3 Column A(id numbers),B(First Name),C(last Name). I have another Excel workbook ...
-
From Excel, Open a word document and goto a page question [Solved/Closed]
Hello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...
-
Getting a Cell to Flash When it's Below a Value [Closed]
Hi I am trying to make cell B3 flash when the value in it drops below 500 and stop when it goes above it. I have this macro running but it does not...
-
Create macro to search for a cell value [Closed]
I have 2 separate excel (2010) workbooks I'm working with and I would like to create a macro that, when run, will copy a variable value that is in cel...
-
Making a counter in Excel.. [Closed]
To Whom this may concern, I have been trying to make a counter on excel. I have been reading some of your posts but they talk about counter with a...
-
MAX value in one coulmn based upon another column [Solved/Closed]
Batch Price Column C 00015 2.75 00015 2.9995 00016 1.89 00017 0.56116 00018 0.1421 00018 0.11808 00018 0.1605 00018 0.12575 00018 0...
-
how to extract particular data's from sheet 1 into sheet 2 [Closed]
Hello I have three different columns in Sheet 1 with names Number, Step Description and Results. Each column have data's up to 100 rows. I want to ...
-
Transferring data from a column into several rows [Closed]
I have data in a column on one sheet that needs to go into several rows in another sheet. Example: Column A has the following data (A1:A200): 1 2...
-
how to remove 0s from excel pivot (2010) [Closed]
Hello, Do you know guys how it is possible to remove zeroes from an excel pivot when the field is not in the report filter but in row label. I have...
-
Highlighti Row/ colour fill through VB [Solved/Closed]
Hello, I am after a code which enables me to highlight/ colour code a row on basis of expiry date and update every time I open that exel file. f...
-
How to do in excel [Closed]
Dear all, Pls suggest for my following issue related to Microsoft Excel. I created a Report in Excel having many sheets. In all sheets, Subscrip...
-
VBA - How to open a pop-up that does not stop the macro? [Closed]
Hi everyone, I would like to add a pop-up (like MsgBox) but I don't want the macro to wait for the user to click on any button. This mean a MsgBox sa...
-
Number of decimals in a conditional format [Closed]
Dear reader, I need to highlight a cell that contains more than 2 decimals. ex. 2,89 is good and should not be highlighted 2,899 is wrong a...
-
Comparing Data in Excel [Solved/Closed]
Hello, I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered ...
-
multiple functions in single cell [Closed]
Hello, I want to put following 2 functions in single cell ROUND((C365*0.9144),2) CEILING((D365),0.05) Pls advise
-
Conditional Formatting Excel 2010 based on content in other cell [Closed]
Hello, I have a conditional formatting issue - and I think maybe the cause is that outcome is already a formula? In cell U5 I have the following...
-
Re: Make a macro run when data entered in a cell -multiple event [Solved/Closed]
Hello, I have three macros in the module and I want each macro to runs when the user changes the values in the cell (Cell F2) to "first", "second", ...
-
compare columns match and insert data from another column [Closed]
Hello, have a sheet with following info A B C D E F G H I J date-sum-item percentage- date sum item now i need to match the date su...
-
Daily attendance sheet that calculates monthly percentage [Closed]
I am trying to design a daily attendance sheet that students sign in on via computer, but I need it to also have a column that shows their attendance ...
-
conditional format [Solved/Closed]
Dear reader, I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel. Example. NL08569638 ...
-
Comparing Data [Closed]
I need to compare data in one column to that in multiple other columns to find missing data. Column "A" is static data, and can be entered into any ce...
-
excel [Closed]
Within an entire excel sheet, I would like the entire row to turn into red font when I type the number 10 into any cell in column H. For example, ...
-
How to print data in multiple excel sheets [Closed]
Dear All, I am new to excel coding. I need help regarding the below issue The below sub routine is the first sub routine. It gets the details fr...
-
Copying Excel Formula in different ranges [Closed]
I want to copy a formula using different data ranges. The formula can't take dynamic range once copied. Example I want to use sumif formula from...
-
Excel Macro - Selection of data from column using flag (0 or 1) [Closed]
Hi, In Excel, I have a column of data and corresponding flags (either 0 or 1) in another column. I want to copy only those data which correspond ...
-
convertion Number into word [Solved/Closed]
Sir, How can convert Number into word in excel sheet. suppose there is 253900 in cell B2 in excel sheet. How can I convert this number as Two lakh ...
-
40 % add formula in excel cell [Solved/Closed]
i want to increse 40% amount in my excel sheet and I have total quantity 90 can anyone like to tell me that how will I entre the 40% in excel cell tha...
-
INSERT ROW DATA INTO EVERY SECOND ROW [Solved/Closed]
Hi I have an excel sheet with blank rows every odd line (i.e rows 2,4,6,8...700 are empty). I have to paste a row of data (the same all the way th...
-
macro [Solved/Closed]
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 13/05/2013 by dhale ' ' Keyboard Shortcut: Ctrl+a ' Application.Goto Reference:="onecell" ...
-
Multiple If Statement not returning numbers - returning words [Closed]
Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, ...
-
How to find out two words matching with one additional Number [Closed]
Hi.. Please tell me how to find out matching two words with only one differnce. If Two Columns of Excel contains Data like Vehcile Numbers MH01A123 an...
-
Greater than/Less than between 2 Dates [Solved/Closed]
i am trying to to populate a spreadsheet that if the date is less than 01/01/2013 then populate the cell with $500.00, if the cell is equal to or grea...
-
Macro to highlight cells. [Solved/Closed]
I am very new to VBA and have spent countless hours looking for help on the web. I have a worksheet with 100,000 rows(locations) and 34 columns(Cha...
-
Lookup/Index data with multiple match [Closed]
Hi, I am not an expert in excel but have some experience. Could some find me some excel formula or VBA code preferably for my data: 01/03/2013 C...
-
Macro to go into a series of Excel workbooks to make a change [Closed]
Hi, I recently got some help to create a Macro to go into a series of workbooks saved in a certain forder to extract a range of information and creat...
-
Ms Excel found a problem and has to be finished [Closed]
Hello, XP, Excel 2002 I have a data sheet with a Line-gragh and scroll bars (up/down) The scroll bar shut increase/decrease a cell value. Done b...
-
HELP ME WITH FORMULAS PLEASE? [Solved/Closed]
Hi all, I need a set of 3 to 4 formulas which would show a monthly grow of accrued interest on each of the new amounts eg: formula 1:Month 1- 1...
-
Conditional Formatting VB [Closed]
Hello, I wonder if you can help me please? I have an excel 2003 document which requires more than 3 conditional formats, i am using this piece of...
-
Macro [Closed]
Hello, I need to insert a multiple rows according to the count mentioned in column d. for example column A,B,C,D contains the data in Column D...
-
Excel Macro To Create New Worksheet [Closed]
I have a invoice tracking spreadsheet, which I would like to update to highlight overdue payments in a new worksheet. I would like the spreadsheet to ...
-
How to work with empty cells in Excel Macro [Closed]
Hello, I want to send email to list of users which are stored in Excel from A1 to A10. But if suppose if any of the cells from A1 to A10 is empty...
-
Inserting pictures into Excel based on file name [Closed]
Hi, I found the below macro on another thread and used it successfully to insert pictures into Column A based on file names in Column B. Howeve...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Install a VPN
- How to Recover Your Yahoo Account