Excel Forum
-
Excel - how do I create multiple spreadsheets from one Master [Closed]
Hello, I have a monthly report with multiple clients which varies month to month. I need to figure out how to create a New Work Book from my sorted...
-
find a column by criteria and display in another worksheet [Closed]
Hello, I have a worksheet with a several columns (example): PP DR MM SS 5 3 2 7 4 9 2 1 2 9 4 4 ...
-
So many dates [Closed]
Hello, I have a spreadsheet of about 15000 items. I need to do several things to the pivot table built off the spreadsheet. The things I need to...
-
trying to create a formula [Closed]
Hello, what I am trying to do is that I have a $ amount in g7;g41 + 20% of the dollar amount in i7;i41 to give total payout in k7;k41 Thanks
-
Enter data in a Workbook worksheet and Save it in a other Worksh [Closed]
Hi, I Created a excel file requisition and user input details requesting materials I need to have this data go to a other sheet with two section ...
-
Is there a way to make a default option for Autofilter? [Closed]
Hello, I have an excel sheet that I am trying to display 3 different tables on, but I want to make it so that I can filter the tables down to just ...
-
Macro to add # of rows based on data in the sheet [Closed]
I am trying to make a guest list that will insert rows automatically and fill in some data. I can get the primary data from one worksheet (i.e. com...
-
EXCEL - Create a bulleted list in a single cell from a list [Solved/Closed]
Hello, I'd greatly appreciate some help with this: I'm trying to get a list of data in cell "D5" only from cells "A1:A10" that do have informat...
-
Excel Spreadsheet date comparison [Closed]
Hello, I am trying to compare 2 columns of data to determine if one date is prior to or after another date. (Is date in column A on, before, or aft...
-
return selected characters in an excel cell [Closed]
I have a alphanumerical number like the following: C297320 I need to return the last 3 digits of this number in a separate cell. Thus, I need...
-
Have macro select range but exclude empty columns [Closed]
Hello, I have a worksheet in which a range gets copied and pasted into an email using a RangeToHTML function from Ron de Bruin's website: https:...
-
vba insert new cell to a dynamic range [Closed]
Hello, Hi, Could anyone plz help me to achieve what I need ? I want a code to insert and autofill a new cell to the range depending on what ...
-
Excel solution [Closed]
I have one Master Sheet, sheet1 in excel 2007 where I have entries of customer details from mixed cities Code ContactPerson Company Add1 ...
-
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 ...
Subscribe To Our Newsletter!
