Excel Forum
-
Excel 2010 code that clears content of a cell on open [Closed]
Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...
-
Conditional formating of row based on other cells [Closed]
Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...
-
Specific data from one worbook to another (Excel 2010). [Solved/Closed]
Hello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...
-
If then formula using a date [Closed]
Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...
-
excel 2007 custom filter problem [Solved/Closed]
Hello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...
-
Macro to Insert Multiple Images to Multiple Sheet of a Excel [Closed]
Hello Everyone, Greetings to All. I have some Issues in the below Macro. My intention is to Copy/Insert the multiple Images in a folder that I se...
-
Multiple columns using countifs [Closed]
I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...
-
VBA/Formulas for Repeating Values by Cell Value, w/Offset [Closed]
Hello, I have a pretty complex little thing going on, but I'm having trouble getting through the next part. Using VBA, two lists are generated ...
-
Making date appear on master copy [Closed]
Could anyone help with a formula for the date to appear on my Master copy of Items sold and purchased. i.e .A. .B. ...
-
Comparing Excel Columns - Help ASAP Please! [Closed]
Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...
-
run VBA automatically when criteria is met [Closed]
I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...
-
time calculation [Solved/Closed]
Hello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...
-
Macro that copies certain cells [Closed]
Hello All , I need a Macro that copies certain cells , from other workbooks in a folder . it should open the first workbook, copy 3 cells , past...
-
Automatic update of date from one sheet to another [Closed]
Hi I need to make a form that will update any written information from one spreadsheet to another automatically. E.g. I have one work-folder wi...
-
How to compare 2 sheets in Excel [Closed]
Hi, Could you please let me know how to compare data in 2 work sheets. I have the data in sheet1 and sheet2. I need to test whether the data in t...
-
Conversion of multiple column into single column [Closed]
Hello, I have a date set in the following format 1 3 5 7 2 4 6 8 I want this in the format 1 2 3 4 5 6 7 8 Please help m...
-
4 conditional formats [Closed]
I am attempting to add 4 conditional formats; First in red the 'cancel' - already done Secondly all things that complete on today's date in blue - d...
-
copy data skipping blank cell [Closed]
Hi, 1. How can i copy my my excel sheet1 (range B2:BJ800) data into sheet 2 skipping blanks cells. All want all data should be on sheet 2, colum...
-
Copying cells [Closed]
My question is similar to those above. We have rental properties. When a guest reserves I enter the data in one sheet (let's call it Sheet 2) that I...
-
Duplicating Macro [Closed]
Hi I currently have the below macro to duplicate rows for me but I want it to show the data in 2 columns instead of nderneath each other. EG OV...
-
VBA to copy and paste between workbooks [Closed]
I need a VBA to copy selected cells and then paste them into a pre-existing workbook. So it will need to open that workbook and then paste. For ex...
-
How to convert number into text in excel [Closed]
Hello, Thanks for the nice solution. I have a problem and that's what should I do if the number is bigger than 999,999,999? Configuration: Wi...
-
formula that i can get a total for D7, if D7= D4 + (C6*D7) [Solved/Closed]
$1,613.00 (Cell D4) (C6) Hours ___ $175.00 (D6) TOTAL (D7) Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C...
-
Simple IF function [Closed]
Hello, I have a column reading random dates (dd/mm/yy) and the column next to it has to read "Y" or "N" depending on whether the date is before or...
-
How to copy data in cell ranges to another worksheet "if" [Closed]
I have a source worksheet that is named "AVDistribution" and has several columns and rows of data and I have additional worksheets in the same workboo...
-
conditional formatting between [Closed]
Hi Ppl have conditional formatted a range of cells with numbers, to turn green if numbers are BETWEEN numbers in Column A and Column B but Proble...
-
auto copying in excel [Closed]
Suppose I have account in say 5 different banks and I have made one excel sheet for each showing date wise transactions. The sheet contains the follow...
-
Comparing unsorted data across separate files [Closed]
I need an automated way to compare the 2 sheets to make sure no equipment gets missed for ordering. I have to compare an order for equipment against ...
-
Calculating a distance within an interval in a cell with text [Closed]
I have a cell that contains words and numbers in the following format: Dig (30'-40', 50'-65'), Fill (70'-90') What I'd like to figure out is a f...
-
If -Then formula needed please... before I head to the roof [Solved/Closed]
Using Excel 2007, I need a formula to do the following: if the date shown in a cell is 1/31/14, display 'monthly activity - january, or if the date...
-
Extraction of Excel data by using an Excel column parameter [Solved/Closed]
Hi, I have a problem in extracting information from an Excel Sheet 1 (entire database), by using an Excel column parameter (Model No) in Sheet 2. S...
-
conditional formating [Closed]
I am working on a spreadsheet that tracks vehicles preventive maintenance. I would like the Mileage Last PM was performed (A1) to turn red when th...
-
Insert number into cell based on other cells containing x [Closed]
I am setting up a spreadsheet tracker for the school. I want J2 to auto fill a price depending on whether C2-G2 have an X. BUT, depending on which c...
-
How to convert numeric to word in excel [Closed]
How to convert numeric to word in excel
-
create a formula such that each cell in a given column auto [Closed]
Hello, Is there a way to create a formula such that each cell in a given column automatically calculates a specific percentage of the value in the...
-
highlight entries one list if they appear in an associated list [Closed]
I wish to highlight entries in one list if they appear in an associated list: I chose to do this by using a modified COUNTIF function, which I had te...
-
Excel Golf Skins Sheet [Solved/Closed]
I need a micro that will highlight the cell with the lowest unique value in each individual column. It would not highlight anything if there were m...
-
Need to merge data logically [Closed]
Hello, I want Macro for below example, SUBACC STMTPG OPBALDT OPBALTP CLBALDT CLBALTP 123abc 1 04-07-2014 04-07-2014 123abc 1 05-07-2014 05...
-
Help to debug this sentence for me please ? [Closed]
Hi, Is there any way I can debug the sentence highlighted in yellow ? Thanks!
-
Copying formula from column to another [Closed]
Good afternoon, I have one calculation sheet with: - lines/column A: containing the items descriptions, - Column B: quantities - Column C: Unit ...
-
Transfer datas from one workbook to another [Closed]
Hello I need your exel help. I need ro transfer rows of datas for columns with values and not transfer those with -. Thank you
-
VB script to notify/popup [Solved/Closed]
I was having a difficulty in notifying my co-worker to print all the sheets on a workbook. I a thinking if it's possible to have an pop-up message to ...
-
How can Copy one Excel Content to a new Excel File By Click Comm [Closed]
Hi dears, i am new user in this site So i hope you will find my requst as well I want to copy the filtered data to my excel file (my excel (Sheet,...
-
Excel - A macro to re-arrange cells [Closed]
I need your help to solve the following problem. I have files containing data about key contacts of company. Company Name,Concerned Person,Designat...
-
help in lookin up a value [Closed]
Hello, I need help in getting a formula in excel i have two sheets the fisrt sheet is the refrence sheet the second sheet is where i write my ...
-
lookuk a value in 2 columns and get value of third (help) [Solved/Closed]
Hello, I have a question I need to lookup a value of col A1 of sheet 1 in col A of sheet 2 and if it matches it gets the corresponding value ...
-
Remove duplicated data [Solved/Closed]
Hi, How do I remove duplicated data from 3 different worksheets in excel ? Like I have a column of client names on each worksheets. I need to com...
-
How to use conditional format on another cell [Closed]
I want to format a cell using 2 conditions from a another variable cell. Example The cell i want to format is A1 using D1. when D1 is between 0....
-
comparing two worksheets with different column values [Closed]
comparing two worksheets with different column values
-
Automation of pie chart using the values in excel [Solved/Closed]
Hi, Anybody knows how to convert values into pie chart using macros instead of the insert function? Thanks!
Subscribe To Our Newsletter!
