The discussions
Protected worksheet
SolvedHello, I would appreciate advice as to whether it is possible to unprotect an excel worksheet if the password is forgotten? If it is possible plea...
Inserting image files from a directory specified by text string
G’day CCM forum Quick hypothetical; I have a list of image file names in a column on an excel spreadsheet and a cell at the top of the page contain...
Copy row only if one cell's value is not 0
SolvedI would like to copy from a sheet to another only the rows in wich a cell ex.A1 has a value different from zero or blank. Thanks a lot!
F2+enter key for macro
Hi I would like to request for a Macro that which execute a F2 and Enter keys. Please don't make a selection for a cells. I have a sheet where ...
Help with simple 2 step macro?
Hello, I ask help to write a macro that 1. searches for 1 name "(Nghiem, Emily)" 2. and then types "X" in the next cell to the right. (What I tr...
Multiple if to show different statuses
Hello, I am trying to have different status in my reports depending on the dates in different cells H START I ACTUAL START J DUE K DATE COMPLETED...
How to get a macro to work in all worksheets
I know I am missing something simple here. I made a macro to create a chart from a template based on two ranges in a worksheet (Brisbane April Sales ...
A variation on the compare 2 columns in excel
SolvedGuys - Please advise and give me a few hints (or if you are generous write a macro for me [only joking ... a bit - please feel free to write it for me...
Search for a word in a worksheet and return row
Hi, Hoping to get some help. I have a spreadsheet full of data in Sheet 1 from A1:AG159382. I would like to use a separate worksheet to search for...
If then formula
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
SolvedHello, 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
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...
If function time
SolvedHello, 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...
Copying an entire worksheet to another worksheet automatically
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...
How to make macro repeat
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
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
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
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...
Fill color of one cell based on contents of another cell
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 ...
Reminder
SolvedFriends 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
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...
Stupefying differential result!
SolvedHello, 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...
Not sure which formula to use? please help
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
How do I test for what quarter of the year a date is in?
Insert lines & sequential numbers based on quantity
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
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 ...
Automatically transfer data
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
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...
How to use macro to generate different reports
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
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...
Dates written in different ways
SolvedHello, 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
ClosedI'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...
Count all cells containing a particular text
SolvedI 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
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
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
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...
Need only comapny name from email add
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
SolvedHello, 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. ...
What is vba code to find if an active cell has a button over it?
ClosedHello, 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...
Ask a question message list topic thread forum list report macr
ClosedI 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...
Transfer data
SolvedHello, Is it possible to transfer data for sheet 1 to another sheet i select form a drop down box that contains all the sheet's name in that wor...
Pop up reminder message in excel
Hi Guys, I'm just wondering if you would be able to assist me with this one, I have been trying to work this out myself but this is causing me a g...
How to calculate no of days between dates
Hello, How to calculate no of days between one constant date not written in excel sheet i.e. 31-03-2016 and other dates which is written in excel ...
Hiding rows when validation list is changed
SolvedHello, I have a excel sheet where have two sets of product line. I would need only details for one set of product line visible if i select it in ...
Userform to export data to another sheet
SolvedHello everybody, Please could anyone spare his/her scares time to help me, I'm new in this forum and I hope to be an expert in excel. Your contribu...
Counting and stop counting days in a cell
SolvedHello, I need to create a formula for a cell involving number of days between dates. First cell - counts the number of days before and after du...
Match columns and assign a value from 3rd column
I have a list of ticket buyers from a recent event, including their zip code. I have a separate spreadsheet with every California zip code and it's...
Excel userform question
Hello, I have spreadsheet with a button on it that opens a userform. This userform will populate data to the same sheet the button is on. How do I...
Vlookup formula help please
Solved=IF(PaymentDetails!$B22="","",VLOOKUP(PaymentDetails!$B22,AppMember,4,FALSE))*E22 Please everybody, how do I write this formula so as not to return...
Vba excel 2013 pleae help
Hello, My question is and if this can be done. Say I have a date entered 3/15/2016 and have information in my excel file. Then I have to enter a...
