Excel Forum
-
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 ...
-
Count all cells containing a particular text Solved/Closed
I am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An e...
-
Auto Populating Spreadsheets Closed
Hello, I have a workbook; I want to place a $ amount for a certain type of light fixture and have it populate the amount in a certain column for onl...
-
Payment Transfer Closed
Hello, I have a spreadsheet with the following columns on a sheet called PAYMENTS D=name E=date F=Payment G=ref# I also have addit...
-
if formula question Closed
Hello, i am trying to write a fomula so that if the text in one column 1 is a,b, or c, than the text in Column 2 is a,b, or c Configuration: Wi...
-
Column A has data return Column C Closed
Hello, If Column A or Column B has a date in it then I need the info from Column C to appear in another column Column A Column B Column...
-
need only comapny name from email add Closed
n excel sheet, i want only company name separately from email address column. Ex. from" mike@edwardstelecom.com " i want the company name i.e edwardst...
-
Removing "FALSE" from an IF statement with a VLOOKUP Solved/Closed
Hello, I would like to remove the "FALSE" result I get when using my IF formula. The formula is a VLOOKUP that is looking at 2 different cells. ...
-
Calculating monthly attendance to percentage Closed
i have a total of 8665 employees monthly attendance and i need to calculate that into percentage for the a month say for the month of March (31 days) ...
-
What is vba code to find if an active cell has a button over it? Closed
Hello, In a column, i have a Macro Button for first row. I have programmed the Macro such that on pressing the Button, a data against the Empl...
-
Comparing Excel Closed
I had a large excel file with multiple pages I was working on and computer shut down and created same file auto saved. I subsequently worked on one o...
-
How to bring searched columns copy and paste another sheet Closed
Hello, I have set of data in sheet one. I have to search particular string in first row, if its found I need to copy that particular column and past...
-
Ask a question Message list Topic thread Forum list Report Macr Closed
I tried the code and I getting a runtime error 9 on the following line Subscript out of range. lMaxRows_t = Workbooks(sBook_t).Sheets(sSheet_t).Cells...