Excel Forum
-
stuck [Closed]
Hello, I'm new to excel's advanced abilities. Is there a way to transfer the total of column E in sheet 1 to cell C3 in sheet 2? Configuratio...
-
Excel 2010 VBA Date Formula [Solved/Closed]
Hi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...
-
Create a Sales by Week Combined Report [Closed]
Hi I want to create a report where I but in sales a use a Macro to insert a date and then insert all of the data in the worksheet into a seperate w...
-
Copy values in row to columns in spaces [Solved/Closed]
Hello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...
-
Excel report [Closed]
Hello, I create a seller report Worksheet 1--- I named it as Price list ... is a Data for my seller report that I set a code, name, points and ...
-
Copying data from one data sheet to another automatically excel [Closed]
Dear Excel Gurus, What I want excel to do is, if a name put in a certain category on sheet one, then it automatically get copied into another sheet w...
-
Adding comment to a Pivot Table using VBA [Closed]
I have a requirement to put comment in a paticular pivot table column . The user can insert column or delete column ,the comment should dynamically p...
-
Formula to perform range of sums based on range of words [Closed]
HI I am trying to find a formula that will basically: Check B2 to see if it contains the word "Fortnight" or "Month" or "Annual" and then "equal th...
-
Compare multiple spreadsheets + conditional pivot formatting [Closed]
I have a list of 200 locations that are looking to renew their internet contract. I am asking 30 different vendors to provide their best available pri...
-
Tranferring Data from one spreadt to another [Closed]
How do I transfer info, including the result of a formula and keep them updated from one spread sheet to another
-
Conditional Formatting [Solved/Closed]
Suppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...
-
Movind data from one cell to another via a Macro [Closed]
Hello all-- I am in need of someone's valued assistance. Here's the story: I have an excel spreadsheet that contains address data in Cell B6 & B...
-
REMOVING " FALSE " VALUE IN "IF&quo [Closed]
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Fix a Blurry Snapchat Video
- How to Disabled Write Protection on a USB
- How to Get Free Diamonds in Free Fire
- Computer Boots to Black Screen
- Facebook Code Not Received
- How to Get More Followers on Instagram