Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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)...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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. ...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
