The discussions
Formula to check days of the month and display only weekdays
Hello, Pls help me I want a formula in excel that checks the days of a given month in turn and display only weekdays (skip weekends Friday and...
Multiple sheet, find, copy specific cell and paste
Hello, i have a challenge for you. Im working on a doccument to pull information from a different sheet, that was imported from a web based huma...
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 ...
Microsoft office adding publisher
I purchased the 365 days of Microsoft Office along with my new computer in December and it didn't include Publisher. How can I add that?
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 ...
Ibm lotus symphony
Sir, I tried severel times to download ibm lotus symphony but failed. please help. With regards Mantu
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...
Outlook 2010 configuration for mail.com
SolvedHello, I am not able to configure outlook 2010 for mail.com. OS- window 7 64 bit Could you please provide me the server, port details.. Thank y...
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...
Ms publisher software
I downloaded the software for Publisher and lo and behold! IT IS IN FRENCH - I think! It definitely is not in English which is the only language I u...
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...
Problems with outgoing server sending email (gmail-outlook 2007)
Hello, i have problems to send email (gmail)/outgoing server IMAP outgoing serv setting smtp.gmail.com SSL 465 req sign in user name password...
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...
My account is block since 3days ago and have upload my i d
Please help me out
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...
Can't open pdfs on my mac
Hello, I received an email with some pdf attachments. When I click on the attachments for preview I get a message that states that the image shoul...
