The discussions
I cant open my exel .slxs files
SolvedHello, am not able to open my exel files(office 2007) which are in .slxs formet. when am trying to open that file windows is showing this message: ...
Enter start time and end time
Hi! I'm trying to make a tracker using excel wherein we can calculate the minutes used in each task that we make. I am planning to have the start time...
Vba code for document controll & progress monitoring
Hi... Good day! I am a project control engineer dealing with almost 1500 documents/drawings from my engineering sub contractor. Each documen...
Enter time by clicking on a cell
SolvedHello, I need help setting a code in Excel. I am new to VBA but have used Excel for awhile. I would like to set Columns D & E up for time. I want...
Conditional formatting with an exception
Hello, Im trying to conditionally format the results in I19:I44 for all duplicates although I want the first one to be an exception. How do I sp...
Freezing panes
Hello friends, I want to freeze more than one row (like 5, 8, 20, etc) and column (like E, K, O, etc) at random location at the same time in excel....
Attendance sheet
Hello friends, Please help me for following issue. I have created an attendance sheet in excel having 12 sheets (for all months like Jan, Feb, ...
A macro for a single column until end of data in the column
I need to create a macro that created "Replacement Date" in Column AE and calculates the Replacement Date for the entire column and stops at the end o...
Selecting dates
I have a worksheet that list property sales from year 2000 to 2012. I'm trying to mark all property sales into different quarters that is all sales fr...
Data search and corellation
Hello I have hundreds of pages of data that I am going through for Pie and Pareto analysis and I am trying to speed up the process by using formula...
Excel - macro help please!!!
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 sorte...
Conditionally insert a duplicate row
SolvedI have a table with hundreds of rows but here's a basic example: __a___b_____c____ 1 Color Dates Completed (headings) 2 red Date1 No 3 red Dat...
Cell contains value from range return value from another column
How can I compare two columns of data and return a value from another column? If the value from column A on Sheet 2 contains a value from Column A ...
Inserting rows chronologically while maintaining weekday formula
Hello there, In a sheet named Projects, col C contains weekday dates and col B has numbers of days needed for projects (a project takes at least 1 ...
Macro help copy specific text from one cell into another
SolvedHere is the scenario: I have a large excel spreadsheet and I have a column in which I only need the last ten characters of each line copied or move...
Capturing time through excel macro
Hello, I am trying to capture the timings of my team for various activities like break, meeting, working hours, login & logout timings etc...I hav...
Excel - how do i create multiple spreadsheets from one master
ClosedHello, 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
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 ...
Trying to create a formula
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
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?
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
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
SolvedHello, 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
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
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
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
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
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
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
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
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?
SolvedIn 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
SolvedHello, 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
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
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
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
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
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 ...
Transfering data from one sheet to another, but not duplicating.
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
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
Hello, Column A Column B: WEST-WARD,INC. 00015 WEST-WARD,INC. 00015 HOSPIRA 00016 ROXANE LABS. 00017 GLOBAL P...
Conditional formatting in excel
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
SolvedHello, 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
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
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
SolvedHello, I have an Excel document which I have inserted some VBA code to open a word document; Set WordApp = CreateObject("word.Application") Wo...
Create macro to search for a cell value
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..
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
SolvedBatch 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
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 ...
