The discussions

Help! need to copy only some columns in rows that have x condtn

 Solved

OK, Full disclosure, I am a Novice Excel user at best.....I have a Google Sheet Workbook that contains Google Form Responses (the Sheet name that thes...

5 replies Last reply on 11 Jun 2016 by
vcoolio

Use of '@' in formulae

 Solved

Hi, I have received a spreadsheet with cells in column E containing the following formula [@[Retail Price]]/[@[Pack Size]]*100 Where the "Reta...

6 replies Last reply on 10 Jun 2016 by
Quarterp

How do i change date format in (dd.mm.yyyy)

 Solved

Hello, How do I change the date format from (dd/mm/yyyy) format to (dd.mm.yyyy) format? And how can I get today's date in dot format (dd.mm.yyy...

6 replies Last reply on 10 Jun 2016 by
Catherine

Conditional formating question

 Solved

Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has ...

2 replies Last reply on 8 Jun 2016 by
sforde

If formula with dates

 Solved

Hi, I would like to set an IF formula which flags me if someone has been working with us as temp for more than 12 weeks... so I have start date and en...

2 replies Last reply on 8 Jun 2016 by
CeskyWater

Creating master spreadsheet for mailing information

 Solved

Hi there, So I am creating a workbook, for work, for our marketing, and I need help. We are completely revamping what has been done before and I wa...

12 replies Last reply on 3 Jun 2016 by
vcoolio

Macro only for alphabetic sheets

 Solved

Hello, I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z Thanks & Regards...

2 replies Last reply on 3 Jun 2016 by
smuneeb

Excel vba to open a eula script when opening a spesific workbook

 Solved

Hi Everyone I am busy designing a training pack with formulas in a excel workbook using MS Excel 2013 and have it already password protected using vb...

3 replies Last reply on 2 Jun 2016 by
vcoolio

Copy all rows with specific name to new sheet

 Solved

Dear Friend, Am having a Excel Timesheet with following columns SITE - EMP NAME - EMP ID - EMP JOB TITLE - DATE - TIME IN -TIME OUT - TOTAL - NOR...

15 replies Last reply on 1 Jun 2016 by
vcoolio

Converter for pdf to word document

 Solved

Hello, I would like to know how to get the software for converting PDF documents to Word documents.

2 replies Last reply on 1 Jun 2016 by
ccmmember

Macro that will allow tab 1 's information to be copy to tab 2

 Solved

Hello, Please help. My Excel Workbook has two tabs. Tab 1 contains all project information such as project number, customer name, project name, co...

2 replies Last reply on 28 May 2016 by
HappyPerson

Transfer a row of data from one sheet to another same workbook

 Solved

Hello, I am trying to transfer a row of data from one sheet to another in the same workbook but my code is not working could anyone help me thanks...

25 replies Last reply on 28 May 2016 by
vcoolio

Convert number to letters in excel

 Solved

Hello, I have to define the numbers to their associated letters and based on the combination of numbers the next cell should show the letters. ...

25 replies Last reply on 27 May 2016 by
hachiya

Convert date of birth into words

 Solved

Sir, Kindly help me in changing date of birth into words. Example:20.03.2001 as twenty march two thousand one

1 reply Last reply on 27 May 2016 by
vcoolio

Automatically moving data

 Solved

Hello, I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I ...

22 replies Last reply on 27 May 2016 by
vcoolio

Location master file in excel

 Solved

I have location master file in excel. 1) I have another file in A2 column there is a address like 422, Ashok Vihar, New Delhi, 2) i want to brin...

1 reply Last reply on 24 May 2016 by
ac3mark

If statements

 Solved

Hello, I have a scenario working with a time sheet. So basically the way payments work is from 30 minutes to 5 hours is automatically 5 hours of w...

1 reply Last reply on 23 May 2016 by
ac3mark

Memory card password recovery

 Solved

Hello, i have nokia 5130 expressmusic mobile phone with 2 GB micro sd memory card .ihave forgot the password of memory card can any body tell me the...

2 replies Last reply on 19 May 2016 by
emon

Verifing-vin numbers

 Solved

Good Afternoon, I have two Excel Worksheets, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to comp...

4 replies Last reply on 16 May 2016 by
AndreOrion

Formula that searches in a row for a cell/column that contains

 Solved

Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...

2 replies Last reply on 12 May 2016 by
Zellie

Error in vba

 Solved

Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...

1 reply Last reply on 11 May 2016 by
Newmie2013

Replace function in macro

 Solved

Hello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...

6 replies Last reply on 10 May 2016 by
TrowaD

Securing a excel workbook

 Solved

Hey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...

2 replies Last reply on 10 May 2016 by
Newmie2013

Copying function using vba

 Solved

Hello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...

5 replies Last reply on 10 May 2016 by
Newmie2013

Dell inspiron 1545 system/admin. password

 Solved/Closed

Hello, my friend bought a Dell Inspiron 1545 at an estate sale.It has the system/administrator password enabled. I'm hoping someone can try to generat...

Last reply on 5 May 2016 by
TONY

Copy formulas from one sheet to another all at once

 Solved

Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...

2 replies Last reply on 4 May 2016 by
vcoolio

Excel doubt - if formula

 Solved

Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...

3 replies Last reply on 29 Apr 2016 by
Joao Brito

Add worksheets to excel workbook using count defined name

 Solved

Hello, I need to add worksheets based on a count which I defined as ADDTABS located in cell B4 on a worksheet called QRY-CMW. The worksheets ne...

2 replies Last reply on 27 Apr 2016 by
raungst98

Publisher?

 Solved

Hi, just joined looking for Publisher, which I thought I had found. The only problem is it ask for a key code and it is all in French. Advice please?

3 replies Last reply on 25 Apr 2016 by
TrowaD

Pdf e-mail attchmnts open to word by default

 Solved

Hello, When I receive an e-mail with a pdf attachment it opens as a word encoded document (e.g. garbage). I need to change the default settings f...

14 replies Last reply on 22 Apr 2016 by
PC

Text format to date/month/year on excel

 Solved

Hello, I have a huge list of data that has multiple dates/year along with different time format. I want to delete the time and obtain only the d...

20 replies Last reply on 22 Apr 2016 by
ExcelNewbie

I want to retrieve value from multiple sheets of same workbook

 Solved

Hello Everybody,.. I have a situation where I request your support, My active workbook has 4 working sheets (sheet1- Master, sheet2, sheet3, sheet4...

9 replies Last reply on 22 Apr 2016 by
Mikkelo

Copy range data in a column to new column.

 Solved

Need help here please !!! Data available : A range of data in a column. Some of the cells are blank. My requirement : Is there any formula where...

6 replies Last reply on 21 Apr 2016 by
anthonyishere

Compare two columns

 Solved

Hello, In the excel, I need to compare Only portion of text in two different columns and return the value in third columns. say example One column...

2 replies Last reply on 21 Apr 2016 by
kumar

Counting number of times a value appears if..

 Solved

Hello, I conducted a survey in which some questions allowed more than one response. Using Excel - I'm trying to count the number of times a cert...

7 replies Last reply on 21 Apr 2016 by
sambr22

Transfer an entire row from one sheet to another

 Solved

Good Evening, I seriously need major help. Please!! Please!! Please!! I have an inventory of over 600+ items (rows) each row has 12 columns with...

5 replies Last reply on 20 Apr 2016 by
vcoolio

Add to excel macros

 Solved/Closed

Hello, I'm looking to edit a macros code and I'm having some issues. Right now our workbook includes a growing amount of days on a project (day 1, d...

Last reply on 20 Apr 2016 by
vcoolio

Protected worksheet

 Solved

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

2 replies Last reply on 18 Apr 2016 by
whatsit

Copy row only if one cell's value is not 0

 Solved

I 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!

3 replies Last reply on 18 Apr 2016 by
vcoolio

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

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

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

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

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

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

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

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

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

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
Results 601 - 650 out of a total of 2,608