The discussions
Transfer data from one excel worksheet to another automatically
ClosedTransfer data from one Excel worksheet to another automatically. we have 8 employees that enter job quote information onto their individual worksheets...
Macro to delete rows between named ranges in excel
How do I delete all rows between named ranges? I have a scenario below Name Range 1 : SUBHEADER_001 (A1:E1). Displays Headers Name Range 2 : SU...
I need help in my project
first see this picture http://img713.imageshack.us/img713/6725/d9i8.png now what i want is, after typing the '2' in B2, i press Enter, D2 will be ...
Popup reminder based on date and additional celll values
SolvedHi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...
Pdf converter to excel :
Hi, I saw https://ccm.net/downloads/tools/5605-pdf-to-excel-converter/ product. This product is very good. Is this a free version available ?. ...
Macro to populate formula using autofill
i have 2 worksheets, A & B. In worksheet A, i have the data in cell F2, F3, F4. In worksheet B, i would like to refer worksheetA!F2 in Column G,...
Help with a formula 'isblank refer to another cell"
I need a formula that will give me number of days between two columns Which contain dates, if one or the other has no date populated it would then ref...
Averaging & assigning blank cells a specific numeric value
Good day everyone. I'm sorry if this seems remedial, but I'm having trouble with a spreadsheet. Here's the gist of my problem: Within a row, I have se...
How i convern number to spelling in excel
Dear friend, This is my problem. Please solve it.
Pull values from conditionally formatted cells - excel 2013
hello, I have a large data set wherein I am trying to figure out where certain values fall and am applying a cell color using conditional formattin...
Comparing columns
Hello, I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000 custome...
Hide rows with zero value in multiple sheets
SolvedPlease help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...
Populate rows on sheet1 based on values in sheet2
Hi, I need to populate rows in sheet1 -- S.No, Name , Address, Contact No. with the values present in sheet2 -- S.No, Name , Address, Contact No. ...
Pop up alert
Hello, I have created a worksheet with macro to enter current time by clicking on a cell. For example, double click on A1 to enter current time th...
Display formula in cell with values
i need to display the used formula in another cell as it is with substituting the values. example: if A1=100, A3=200, B1=206 formula is =SUM(A1, ...
Macro for copying sheet 1 into sheet 2 and then deleting data in
i need macro for copying sheet 1 into sheet 2 and then deleting data in sheet 1 and sheet 3 plz help
Conditional formating
SolvedI have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...
I need to run multiple automatic macros in one sheet
I am developing a worksheet where there are multiple occasions down a list where users will have to select an option from a drop-down box (Y, N & N/A)...
Convert a date field in excel to day of week
Solved/ClosedHello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...
Date format
in MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows 02/10/2007 i...
Conditional formatting of cells with dropdownlist
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
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
SolvedHello, i m making a sheet with this function =IF(H1
Macro to transfer data from one sheet to another
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
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
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
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
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
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...
Pls suggest for excel
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
SolvedDear 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...
Help!! excel 3 year reminder
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
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
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
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
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
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
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
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
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
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
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
SolvedI 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
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...
Adding columns containing text
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
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
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...
Excel, automatically transfering data and filtering
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
Hi, Would appreciate helps here. I need to calculate monthly contract value based on contract start date and finish date. Contract value: 100,0...
