Excel Forum
-
formating cells [Closed]
i am trying to change the colour of a cell based on the value of two other cells in Excel 2010. for example if R1 is the same value as C6...
-
Simple Point of Sale [Closed]
I have a relatively simple task that I'm hoping I can accomplish in excel. I'm putting on a college fundraiser selling four items and I have a...
-
VBA to put formula into cell [Closed]
Hello, In a effort you keep you guys challenged. And obviously improve my VBA writing skills...I really appreciate all the responses I have...
-
Excel [Closed]
Description: 1. I have an excel workbook containing multiple sheets (about 28-33) eg. Book1 and the worksheets are labelled eg. 01-March DS, 02...
-
VBA Macro to export data to a new workbook [Closed]
Hello all, Trying to create a macro in VBA but getting some problems starting with it. If you can help it would be great! Going to summarize...
-
VBA - criteria lookup and the removing formula from cell [Closed]
Hi, Could someone help... I have written some code but cant get it to do exactly what I want, and think I have over complicated the...
-
Filtering data from 1 sheet to another [Solved/Closed]
Hello, I have the following problem. Kindly help me with the same: Problem statement: I have data pertaining to projects, milestones and...
-
If row is checked copy it onto next available row on 2nd sheet [Closed]
Hi Excel Folk and Friends of Michael, I have sheets and sheets each day of potenital 'buys' - when I get one I like I have to copy it onto...
-
If formula using dates and texts [Closed]
I want to write a formula which will show either Q1, Q2 Q3 or Q4 depending on the date I the next cell (written as 01/01/2014).
-
Using a selected criteria to copy cells into new sheet [Closed]
Hello, I have written a spreadsheet that is basically a dashboard for data... I have hit a small snag as usual the business wants to over...
-
To show blank record when no data while copying [Solved/Closed]
Hello, I have three sheets sheet1(Active) ,Sheet 2(Inactive) and Sheet3(Total). I have written code which would copy data from Active sheet...
-
add value to one cell if multiple other cells have any value [Solved/Closed]
Hello, I'm trying to create a spreadsheet where: if A1 has any value, 10 is added to the total sum in G1 if B1 has any value, 20 is added...
-
How to auto merge same value cells. (H\V) [Closed]
Hello, I want to merge same value cells in both rows and columns. for example i'll be having: | 2 2 2 2 2 3 3 3 3 3 | 2 2 ...
-
Change content of one cell based on content of another [Closed]
Hi! I'm looking for guidance on a formula/macro/etc that would enable me to have content of a cell changed based on the content of another cell in...
-
Collect data from drop-down list from multiple workbooks. [Closed]
Hello! I have a question. Let say, I have workbook 1 (WB1), workbook 2 (WB2) and workbook 3 (WB3). All basically are the same workbook, just...
-
How to go to a particular cell while input its content in a box [Closed]
Hello Trowa & Experts, I have an excel data sheet with columns 250 odd. Column headers have numbers like 100,101,102,103 and so on till 250...
-
Filtering and copying data from one sheet to another [Closed]
Hello, Problem statement: I have data pertaining to projects, milestones and tasks in sheet1. I want this data to be filtered on the basis of...
-
Conditional formatting for cells depending on other cells ranges [Solved/Closed]
First off, I am not even sure if i worded my question correctly, so sorry if i have. What i want to do is... have for cells b4:b7 to have on...
-
macro extracting data from different sheets within a workbook [Closed]
I need help creating a macro to copy data from multiple sheets within a workbook into one master sheet. I have tried several times and remain...
-
How to see if a particular cell in a table has date data or not [Solved/Closed]
Hello, I am preparing a tracking tool to measure the life of an item. The table has Installation No Date 1 ...
-
formula calculate daily income in excel [Closed]
I'm using excel to calculate my income and expense on monthly basis using sum() but I need to calculate daily basis. my data as follows A1 =...
-
Highlight the linked cell depends on drop-down list choice [Solved/Closed]
Hello, I have a question. Let say I have a table containing number 1,2,3,4 and 5 in A1:A5. In another worksheet, I have "Student" in A1 and...
-
Conditional Formatting: Merged cell color [Solved/Closed]
Hi, This is probably an easy solution but for the life of me cannot get this to work. I have a situation whereby I have a line of...
-
Calculating Due date based on multiple criteria [Closed]
Criteria 3 products, choose one classification, one category, all time frames are different Products: HBX, Flex, NYM Categories: Complaint,...
-
duplicate values at the bottom, not at the top [Closed]
Hi , The below formula gives me the results for AT column at the top of each duplicated code in column AJ. How could I make it to give me the...
-
Array formula to nest several optional values from same cell [Closed]
Hi, All the OR statement formula below refers to the same cell AL2362. How could I make an array formula to put all the OR values in one...
-
Counting cells containing only numbers [Closed]
Hi all, counting cell containing only numbers Is there a formula to count only cells containing any numbers in general? Moreover, is there a...
-
Copy data from current work to another [Closed]
Hi I am using the below code to copy data from Current Work To Another Sub RunMe() Dim lRow As Integer lRow =...
-
compare three columns contain same characters [Solved/Closed]
I have three columns of form security access in an application for different classes. The security characters may be in any order. I need to...
-
Still learning [Closed]
I have an excel invoice made up with guest details. I need to place information into another spread sheet, this gets rather tedious to do every...
-
How do I automate my Excel worksheet [Closed]
Hello, I have a workbook that contains two worksheets, sheet 1 is my budget worksheet and sheet 2 are the invoices paid. I want to take sheet 2...
-
Excel: Partial Matches in 2 Different Cells [Solved/Closed]
Hello, I've been mulling over this all afternoon and need some help. Here is what my sheet looks like: K L 3 ...
-
Copying the entire row using VBA [Closed]
Hi! I need a code that will automatically copy the entire row to another sheet (same file) when a condition has been satisfied. See the...
-
highlight cell if the finish date of a task is less than x days [Closed]
Please could somebody help me with this problem. I have a spreadsheet and i would like make some cells to go yellow if the finish date of a...
-
Function or Macro to read cells in a column and color them [Closed]
Hi Guys, I need to write a VBA macro or a formula/function, which actually reads the value and color of cells in column and in turn color other...
-
how to calculate number of days between dates [Closed]
Please I need ideas of how to get the number of days between to sets of dates in an excel column. The preceeding dates all the way to the end of...
-
VB code to email at File Save is nnot auto-running [Closed]
Hello, all, I hate to rehash this old message, but since Microsoft never stops messing with things, I suppose threads like this will never die....
-
VB macros extract data containing ".CF from a particular cell [Closed]
Hi, i would like to know how to extract data containing ".CF from a particular cell and to a different workbook with the entire values of the...
-
comparing 2 excel with diff length [Closed]
I have two columns of numbers A B 123 223Abc 223 334ssd 334 368def 456 456def i want to...
-
If date range, then % commission. [Closed]
I am trying to create a formula that will look at a group of rows and calculate a percentage of a particular date range of money. The rows have a...
-
formula that allows it to calculate the sum of [Closed]
Hi ! I'm looking to create a formula that allows it to calculate the sum of.. =SUM(D3*E3+D4*E4+D5*E5+D6*E6)... but it needs to do this...
-
determine percentage via formula [Solved/Closed]
Hello, can anyone help me determine a formula that will give me a percentage? If N11 is 2500 and I11 is 84, I need a formula that will help me...
-
VBA - insert pictures into excel [Closed]
Hi there, I am trying to write code to insert pictures based on the file name in column B4, with the picture to be displayed in Column C4. This...
-
Help Creating Macro [Closed]
Hello, I hope someone can help me since I don't have the knowledge to do it. I'm trying to build a macro that check the value in an excel...
-
Copy data from two columns to third columns on a condition [Closed]
Column A1 containing the current day =today() From B4:B33 the dates from the beginning of the month till end of the month From C4:C33 the...
-
How to calculate percentage of savings [Closed]
Sir, Im going to invest in a gold saving scheme .12 months scheme 100 per month at last they are giving 50 as free .how to calculate the...
-
Excel invoice w/data from spreadsheet 1 and update spreadsheet 3 [Closed]
Good morning experts, I sincerely hope that you can help me out. Currently, we use an Excel template to write invoices (a modified Excel...
-
How to calculate the average of a range day by day? [Closed]
Hi all, How to calculate the average of a range day by day? A is the column for the day, and the average should go at the top of each day. I've...
-
Change the rows font colour based on one cell [Closed]
Hi I would like to create a rule to change the whole rows font when something is put into any cell in column V - who do I do this?
-
two values to find on the same cell [Solved/Closed]
Hi, Can the below be shorten up? It's basically to count if "dr" or "ba" are in cell...
