Excel Forum
-
Conditional Formatting - based on a formula and named cells [Closed]
Hello, I have been struggling to get a simple formula to work in Excel 2013. My objective is to compare budget numbers to actual and if we are wit...
-
Trying to write a code to insert a blank row above a cell value [Solved/Closed]
I am trying to write a code that will auto insert a blank row above a certain cell value ie: existing: Column G 5 10 20 22 999 2 22 55...
-
Macro for deleting a row with specific criteria in a cell [Closed]
Hello, I've got a spreadsheet with many rows and columns, and I'd like to delete specific rows based on criteria I pick. For example, if my criteri...
-
highlight dates with conditional formating [Closed]
CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5= 09-JAN-2013, A6= 10-JAN-2013 Here a1 and a2 has difference of 1 day so...
-
Exporting selected cells to another workbook selected cells [Closed]
Hello, I am a College Student and in my down time I've been messing around with vba coding. I am thinking about making a macro that will automatica...
-
Adding columns containing text [Closed]
I have a basic sheet and cell a4 is a total of jobs done. I want to add +1 to cell a4 every time I enter any text in b6:b1000 to tally work completed...
-
Excel reminder [Closed]
Hello...I need to create a reminder for dates in B2 that is 3 years after the date in B2. To have B3 highlight with REVIEW would be great. I have a fo...
-
Command button to post data from one sheet to another one [Closed]
Hello, I would be very grateful if some one van help me! I have excel table with 10 columns (from A-J) in sheet1. I fill data in the table and in...
-
VBA code to update master excel sheet from source excel sheet [Closed]
Please help me with a vba code to update redhighlighted cells in master file for all documents from source file please find links for the files ...
-
Excel, Automatically transfering data and filtering [Closed]
How do I transfer a document into another document automatically by filtering specific numbers or words out?
-
Formula to calculate monthly contract value between date [Closed]
Hi, Would appreciate helps here. I need to calculate monthly contract value based on contract start date and finish date. Contract value: 100,0...
-
I cant open my exel .slxs files [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Solved/Closed]
Hello, 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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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 [Closed]
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!!! [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 sorte...
-
Conditionally insert a duplicate row [Solved/Closed]
I 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 [Closed]
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 [Closed]
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 [Solved/Closed]
Here 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 [Closed]
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 [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 ...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- Computer Boots to Black Screen