Excel Forum
-
Insert Rows according cells value in excel table [Closed]
Dear All, I need a Module that allowed me when I run it to add Rows down according upper cells Value for Example; Total Names 2 Sami 5 Rami ...
-
If there is value in one column then a $ generates in another [Closed]
Hi there, I am trying to create an excel formular where in Column G I have a drop down menu with either Long Hire or Single Hire as the options. W...
-
Number to Words [Closed]
Dear Kioskes, Ex: 45,450.55, Forty five thousand four hundred and fifty & 55/100 only could please replay me
-
Adding 1 to an existing number if criteria is matched? [Solved/Closed]
In column A I have a set of initials and in column C I want a number that corresponds to the number of times the initials have appeared... Column ...
-
Find the sum of data that has multiple conditions in Excel [Solved/Closed]
Hello, I have a large data table, and I want to find the sum for certain data that fits a few criteria. Here is a simplified example: __a_____b__...
-
Formula [Closed]
Hi, I need to create a formula for a whole team. It is based on the number of people in the office for each calendar month. The spreadsheet I have ...
-
pdf to excel convertor [Closed]
Dear Sir, I want to install pdf to excel convertor to my PC! Help me pls!
-
Formula for change of dates daily for one month of working days [Closed]
Hello. I am looking for a formula to add one day to a column of working days in a month. I wish to start the first cell in the column to 1/07/2013 an...
-
VB Column Width and Sheet Name [Closed]
Hi, I am really new to VB, but I work a ton with Excel. I have a spreadsheet that I have to parse out into multiple spreadsheets for some reporting p...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account