Excel Forum
-
Conditional formatting of cells with dropdownlist [Closed]
In column C of my spreadsheet i have created a drop down of a set of 96 locations in US. When i select a certain location from the drop down , i want ...
-
Comparing columns and returning value [Closed]
i've following: 1. Drop down values from 1 to 5 in column A. 2. Drop down values from A to E in column B. Ive following matrix (A44:C68): 1 ...
-
some help needed about IF function with dates [Solved/Closed]
Hello, i m making a sheet with this function =IF(H1
-
Macro to transfer data from one sheet to another [Closed]
Hello, I would like to know whether this is possible using macros in excel Sheet 1 Column A Column B Column C Column D Column E C...
-
Deleting a row [Closed]
I have an Excel file with rows from 2 to 988. There are two columns B titled Customer and C titled Main Email. I need a macro that will search column ...
-
Transferring Selected rows to Another location on anothersheet [Closed]
I Am trying to Move a selected range of cells to another sheet. As an example "sheet1" Columns C,D,E,F,G,has a data list entered and when i enter th...
-
Odd situation in Excel [Closed]
Hello, I'm designing a spreadsheet for my work in terms of I've got a set of numbers from 0-99, the evens are one week events and the odds are ano...
-
Substracting time from date & time to determine the date & time [Closed]
I have a 'simple' spreadsheet with five columns (warehouse #; part #; departure date & time; transit time and arrival date & time). I have packages...
-
Help with macros in excel [Closed]
Hello, I was wondering if anyone could help me in creating a macro file for excel....I am needing to save, print, and close an excel file at a cer...
-
Need Macro for Generate report table based on some critera [Closed]
Hi, I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Exa...
-
Pls suggest for 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, Subsc...
-
creating pdf from selected cell range [Solved/Closed]
Dear all, greetings. firstly , I would like to thank those who have helped me to get below code (to create pdf file for selected cell range) whic...
-
how to compare two coloumns in excel [Solved/Closed]
Hello,
-
HELP!! Excel 3 year reminder [Closed]
I have a formula: =TODAY()-$B2>3, this will remind me 3 days before a due date, but I need it to tell me to review after 3 YEARS of the dates I have i...
-
Please help- conditional formatting [Closed]
Hello, I want help to solve below described question for excel 2007. CELL A1= 01-JAN-2013, A2= 02-JAN-2013, A3= 05-JAN-2013, A4= 07-JAN-2013, A5...
-
Formatting Excel [Closed]
Hello, i got a problem regarding excel formatting. Excel displays every figure higher then 1.0 as a date and anything lower than that as the ac...
-
i lost data [Closed]
Hello, i had a file with some data and one of my kids entered this file and changed evrthing and saved the data. and i need the old data. how can ...
-
Macro to insert a row after 6 rows and 45 rows [Closed]
Hi all, I'm new here and hope you guys can give me some advice and help to end my problem! I have a large data set containing "control values" a...
-
Macro Insert Headers after sorting [Closed]
Hi All, I have a spreadsheet that would contain a hundreds of thousands of invoices. But to simplify, I am more concerned about the following: H...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account