Excel Forum
-
Update data records Closed
I have a specific range of cells in a column. For eg In sheet1 from D3 to D12 I keep on entering various alpha numberic code from 3 digit to 8 di...
-
copy row paste at the top of each page Closed
I need to copy a row, then paste it on the top row of multiple pages.
-
Validation Warning for repeating a number in a column Closed
Hello, I am using a spreadsheet that compares properties, within different grid squares. The column for grid references has numbers prefixed with t...
-
Excel : If value is in column A, then delete cell in column B Closed
Hello, This is what I want to do : Column A : value1 value2 value3 value4 value5 Column B : value1 value22 value33 value44 valu...
-
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 ...