Excel Forum
-
If Then Formula [Closed]
Hello, I am trying to build an If Then formula. I am trying to reference a cell with a specific text in one cell like A2=Light and only if Lights is ...
-
How to change word in cell using another word in another cell [Solved/Closed]
Hello, I have 2 qns 1) Everytime i enter "Sells" in a cell i want another cell to appear "to" and in the same cell if i key "Buys" i want the o...
-
copying macro [Closed]
I want to write a macro where it groups my data by group # and copy the data of each group # into different sheets. Afterward, rename each sheets t...
-
How to extract&automate dailymaster excel sheet using macros/vba [Closed]
Well, On daily basis I get master data sheet and create a excel reports manually, I can add columns and use formulas to get required result, you can s...
-
trying to get an if statement working [Closed]
i am trying to make a formula that when these cells have text in them, a counter goes up. my code here =IF(ISTEXT(C3),1,"")+IF(ISTEXT(D3),1,"")+IF(...
-
Conditional formatting one cell value changes formatting [Closed]
Hello, I am trying to create a comprehensive to do list for my work. I have a "Completed"(A1) column and a "Task"(B1) column. When I enter a va...
-
Compare 2 lists of numbers [Closed]
Hello, I have 2 lists of serial numbers. One is a master list of all serial numbers and is 234 rows by 4 columns. There is a blank column next t...
-
IF Function Time [Solved/Closed]
Hello, I am trying to make a rota and I need help with a formula. A1 B1 C1 07:00:00 14:30:00 =b1-a1 The person st...
-
Check if there is a match to a cell in the rest of the workbook [Solved/Closed]
Hello, I've got a workbook that has divided a list between 10 different worksheets (based upon their categorization), unfortunately, the list that...
-
Making selections for unknown data in excel [Closed]
If i have an excel spreadsheet that has 1491 items in a specific column and i want to select every 149th item in that column so that i select 10 items...
-
if in 1 row one cell are equal to another cell in th 2 row i ... [Closed]
Hello, in excell i have 2 row and i have a cell from 1 row that equal to a different cell from the 2 row i want to copy the content from a different...
-
Copying an entire worksheet to another worksheet automatically [Closed]
Hello, How can I automatically copy all data from one worksheet to another to include charts etc. Basically a copy of another worksheet tab. than...
-
changing font colour in a range based on conditions in another [Closed]
Many thanks for the answer provided so far. But what I actually want have not been solved. For example if any cell value in the range D4:D40 is betwee...
-
How to make Macro Repeat [Closed]
Hello, I am trying to run a macro where I multiply a range (B3: B615) by a number (B2). The problem is I want to do this for every column in my wo...
-
Changing font colour in a range based on criteria in another [Closed]
Hello, I am trying to change the font colour in a range of cell based on conditions i set in another range of cell. How do i go about it, its giv...
-
Relating today to other dates [Closed]
Hello, =IF(M38>=A197;(M38);(O38)) M38 - date for the first payment A197 - =Today() O38 - date for the second payment What I wanted with th...
-
Macro needed [Closed]
Hi, I am a complete novice and have never written a macro before. I have an excel workbook with 1 worksheet called 'VOID MASTER' , I would like a macr...
-
Run-time error '1004': [Closed]
Hello, First of all I am not a programmer so am very new to macros. I have used the TwoSheetsAndYourOut macro which works in general workbooks ...
-
cell data xfer between files [Closed]
Hello, I have two files in separate folders. I want to transfer data from one cell into a cell in a file in a separate folder. If I put = in the mas...
-
Excel: comparing two columns and their rows [Closed]
Help! Here's what I'm trying to do: take a value in the N column of TABLE A, match it to the AB Column of REFERENCE TABLE B; then once that match ...
-
Fill color of one cell based on contents of another cell [Closed]
Hello, I'm using office 2010.. how do i make one cell change color by adding an indicator in another cell... For example..when i put an x in a cell ...
-
If condition [Closed]
Dear Freinds I need your help for below requirement. I have 3 columns. Column contains text like Wk1, Wk2, Wk3. Column 2 and 3 contains numeric va...
-
Reminder [Solved/Closed]
Friends Hi can anyone please help me? I need to set up a reminder in excel. I have a workbook containing a sheet that contains all our permits and in...
-
automaticaly transfer a line of information to another sheet [Closed]
Hello, HI, I have a workbook that has 2 sheets, on sheet 1, I have 22 columns with different information, on sheet 2, I would like to automati...
-
Filter data in a sheet from values in another sheet [Closed]
Hello, I really hope someone could assist me as I am very new to Macro's/VBA and I have a requirement that needs coding. I have a sheet (Total)...
-
Changing values in a cell dependant on another [Closed]
Hi guys, first time on here, i've gone through a few previous posts and found some helpful stuff, but still having trouble with something. I've ...
-
Stupefying differential result! [Solved/Closed]
Hello, in the attached picture you can see that in cell E23 I inserted my budget and in cell E23 I inserted what I actually spent (the same amount) sh...
-
Open Excel files on my Mac [Closed]
Hello, When I open any attachment that is a excel worksheet it goes to all the files in my documents?? help? Configuration: Mac OS X (10...
-
Excel - Repeat certain rows 4 times consecutively [Closed]
Hello, I am a complete novice when it comes to excel so please bear with me. If I had a Data Base of lets say 1000 numbers (0001 to 1000) and...
-
Copy from multiple worksheets to a summary sheet [Closed]
Hello, My name is Nelson, I recently came across your website and i am hoping that my problem can be solved. I am new to VBA. I want to loop th...
-
checking for type of day [Closed]
I need excel to check =if a DATE = Monday, then, else EG; =if(a1=Friday,+a1+1,+a1) =if(a1=Sunday,+a1+1,+a1) I am trying to build a data base wor...
-
Not sure which formula to use? please help [Closed]
Hello, I need a formula to work out the following: 30 meters = 7 squares 60 meters = 14 squares 90 meters = 21 squares etc etc so when I t...
-
Test for quarter of year [Closed]
How do I test for what quarter of the year a date is in?
-
Insert Lines & sequential numbers based on quantity [Closed]
I have an order form with multiple macros including a macro to "Total" each order to show only the items and the quantity of each item that is ordered...
-
change mm/dd/yyyy in dd/mm/yyyy [Closed]
Hello, i have 250+ entries in excel sheet in format mm/dd/yy i want to change all in 1 time in dd/mm/yy format how can I do it. advise me ...
-
Format two-level axis in stacked column chart using vba [Closed]
Hello all, I have a stacked column chart with two-level axis. Please refer the image I want to make the first level axis (a,b,c) font size...
-
Copy conditional formatting- different version [Closed]
Hello, I'm a novice, but have been getting by. The intent is to modify the text of a cell when ordering material, if we have that material already ...
-
Macro of reminder When Time in Particular cells orrurs [Closed]
Hi, Can someone please help on this. I have daily excel to be mainteined in which client assigns me tasks and i need to approach them back withing...
-
Macro for Copy data and paste in all following blank cell [Closed]
Hello, I am working on a data sheet with several columns. I need a macro that copies a value and keeps pasting it in the following rows till a ...
-
Macro Run time error 1004 [Closed]
Hello, I want to write a macro to do the following: Automate an action so that when you select a content from a drop down list, it triggers content...
-
compare 1 date to several dates [Closed]
Hello Excel Experts. Please bare with me as I am trying to use Excel and can't seem to figure out how to proceed and am hopeful yall will be able to...
-
Automatically transfer data [Closed]
Hello, I am trying to automatically transfer data when entered on sheet 1 to sheet 2. Can you please explain how to do this?
-
Graphing gym membership over time [Closed]
Hello, I have a spreadsheet with data on when certain people joined a gym, looking something like this: October 2011 May 2012 December 2012 Oc...
-
1 to many compare [Closed]
I am using Excel 2013. Have a multiple Projects (>1000), each project has a start date. Each project can have several Tasks (1 to many). Each Task ...
-
How to use Macro to generate different reports [Closed]
Hello, I come across a question recently. I am hoping someone could help me. I work for a property management company with over thirty properties...
-
convert number to word in excel [Closed]
Hello, I want to write number but dont want to spell the the same in word please suggest the formula to convert the same. Ex:-6000 Six Thousand...
-
Copy a cell value from most recent workbook from a folder [Closed]
Hello, Dear .. i try to make a excel file for my shop here when i open my work book it should automatically update the cell value from a recen...
-
Dates written in different ways [Solved/Closed]
Hello, I have a spreadsheet with dates written in different ways. August 2010 is written both August-10 and August 2010. How can I change this so ...
-
Excel Macro Help [Closed]
I'm trying to figure out the VBA code or Macro to find the specific text of "AM2," in one column D and if it is there then replace it with the info fr...
-
Help Excel transfer/copy specific data from one sheet to another [Closed]
I have this problem. I have this name and address on sheet 1, then i want to transfer or copy it from another sheet with differrent cell format. What ...
