The discussions

A variation on the compare 2 columns in excel

 Solved

Guys - 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...

2 replies Last reply on 13 Apr 2016 by
BrianGreen

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...

3 replies Last reply on 13 Apr 2016 by
vcoolio

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 ...

3 replies Last reply on 13 Apr 2016 by
vcoolio

How to change word in cell using another word in another cell

 Solved

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...

10 replies Last reply on 13 Apr 2016 by
Cherietan

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...

5 replies Last reply on 12 Apr 2016 by
group123

Outlook 2010 configuration for mail.com

 Solved

Hello, 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...

11 replies Last reply on 12 Apr 2016 by
Rod B.

If function time

 Solved

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...

2 replies Last reply on 11 Apr 2016 by
Ashakil

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...

3 replies Last reply on 9 Apr 2016 by
vcoolio

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...

1 reply Last reply on 8 Apr 2016 by
ac3mark

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...

1 reply Last reply on 8 Apr 2016 by
ac3mark

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...

1 reply Last reply on 8 Apr 2016 by
Ambucias

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...

1 reply Last reply on 8 Apr 2016 by
vcoolio

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...

1 reply Last reply on 8 Apr 2016 by
vcoolio

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...

1 reply Last reply on 8 Apr 2016 by
marlonbrando921

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 ...

1 reply Last reply on 7 Apr 2016 by
Mazzaropi

Reminder

 Solved

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...

7 replies Last reply on 7 Apr 2016 by
vcoolio

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...

1 reply Last reply on 6 Apr 2016 by
ac3mark

Stupefying differential result!

 Solved

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...

4 replies Last reply on 5 Apr 2016 by
j1969c

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...

1 reply Last reply on 4 Apr 2016 by
ac3mark

My account is block since 3days ago and have upload my i d

Please help me out

2 replies Last reply on 4 Apr 2016 by
Ambucias

Test for quarter of year

How do I test for what quarter of the year a date is in?

1 reply Last reply on 4 Apr 2016 by
TrowaD

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...

11 replies Last reply on 4 Apr 2016 by
TrowaD

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 ...

1 reply Last reply on 4 Apr 2016 by
kieferschild

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?

3 replies Last reply on 31 Mar 2016 by
ac3mark

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...

1 reply Last reply on 31 Mar 2016 by
ac3mark

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...

7 replies Last reply on 31 Mar 2016 by
ac3mark

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...

2 replies Last reply on 31 Mar 2016 by
Ambucias

Dates written in different ways

 Solved

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 ...

3 replies Last reply on 31 Mar 2016 by
vcoolio

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...

1 reply Last reply on 31 Mar 2016 by
Computertech

Count all cells containing a particular text

 Solved

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...

3 replies Last reply on 30 Mar 2016 by
RayH

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...

1 reply Last reply on 30 Mar 2016 by
ac3mark

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...

2 replies Last reply on 30 Mar 2016 by
vcoolio

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...

2 replies Last reply on 29 Mar 2016 by
RayH

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...

1 reply Last reply on 29 Mar 2016 by
TrowaD

Removing "false" from an if statement with a vlookup

 Solved

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. ...

2 replies Last reply on 29 Mar 2016 by
RayRay

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...

1 reply Last reply on 29 Mar 2016 by
Computertech

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...

1 reply Last reply on 28 Mar 2016 by
Computertech

Transfer data

 Solved

Hello, 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...

4 replies Last reply on 27 Mar 2016 by
vcoolio

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...

1 reply Last reply on 27 Mar 2016 by
Ambucias

Powerpoint 2003 - application error

After running a custom Windows Update a few days ago, I am now receiving an error message when opening various PowerPoint files: "PowerPoint" was unab...

1 reply Last reply on 26 Mar 2016 by
Ambucias

Password forgotten

Hello, I do not know what my password for my gmail acct is. can you tell me what it is? My account is: ***@*** Configuration: Mac OS X Lion ...

1 reply Last reply on 25 Mar 2016 by
CupcakeQueen

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...

3 replies Last reply on 25 Mar 2016 by
vcoolio

Publisher

 Solved

I downloaded the free version of Publisher but do not see it featured anywhere on my computer?

4 replies Last reply on 24 Mar 2016 by
ac3mark

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 ...

1 reply Last reply on 24 Mar 2016 by
Mazzaropi

Hiding rows when validation list is changed

 Solved

Hello, 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 ...

2 replies Last reply on 24 Mar 2016 by
tani

Userform to export data to another sheet

 Solved

Hello 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...

4 replies Last reply on 24 Mar 2016 by
redbaby

Counting and stop counting days in a cell

 Solved

Hello, 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...

4 replies Last reply on 23 Mar 2016 by
diestra123

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...

1 reply Last reply on 22 Mar 2016 by
Coley925

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...

1 reply Last reply on 22 Mar 2016 by
TrowaD

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...

6 replies Last reply on 22 Mar 2016 by
redbaby
Results 2201 - 2250 out of a total of 12,258