The discussions

My enter keys and arrows stop working in excel. what can i do

Hello, My enter keys and arrows keys stop working in Excel, what can I do to fix this problem/ Thanks for any help. Configuration: Windows / Ch...

2 replies Last reply on 11 Oct 2015 by
rizvisa1

Auto transfer data as i marked

 Solved

Hello, I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related...

1 reply Last reply on 11 Oct 2015 by
rizvisa1

Populating sheet based off date criteria in another

Hello, I have a database that I would like to auto populate all of the 2015 events into a 2015 sheet. I need the data in both sheets as the main i...

2 replies Last reply on 11 Oct 2015 by
rizvisa1

Recover delete data

dear friends i have a word file in 200 pages data but now i am open the file is empty in single page if recover the data?

1 reply Last reply on 10 Oct 2015 by
Ambucias

Pulling data from different workbooks and collating on another

Hello, I would like to be able to do the following; have a number of work books which are allocated to team members (x4) which they complete with ...

1 reply Last reply on 9 Oct 2015 by
rizvisa1

Counting action under condition of theyr value, and month when..

 Solved

Hello Guys, I came here for help again :) I need to solve one issue. I've created database, which contain column with Dates(column E),and column w...

4 replies Last reply on 9 Oct 2015 by
Mazzaropi

Editing a date+time field converts date to text

Hello, I have formatted a (Excel 2010 spreadsheet) column as "ddd\ dd-mmm-yy\ \ hh-mm\ \h\r\s" which shows the existing data as "Sun 04-Oct-15 ...

1 reply Last reply on 9 Oct 2015 by
koorway

Comparing spreadsheets

I have been given a task in Excel and i am not good at it. I have two different spreadsheets with first and last names in them. I need to compare sp...

1 reply Last reply on 8 Oct 2015 by
Mazzaropi

@if formula

 Solved

Hello, how do i formulate the following:- if cell B12 contains the word Meals, then I want to use the formula F12/2 else take 100% in F12 Conf...

5 replies Last reply on 8 Oct 2015 by
BrianGreen

I want to plus data from two excel sheeets to the third sheet

Hello, hi Configuration: Windows XP / Firefox 38.0

1 reply Last reply on 8 Oct 2015 by
xpcman

Delay message

I got a postmaster email that an email sent from computer to someones personal email didn't go and delayed. I think someone sent from my computer to t...

1 reply Last reply on 8 Oct 2015 by
xpcman

Cell formating

Hello, I have excel sheet that contains 1000 rows of customer and i need to change color in one cell based on anther cel in same row ,this i solv...

1 reply Last reply on 8 Oct 2015 by
Mazzaropi

Not able to open pdf files

Hello, Please can you advise me why just suddenly I cannot open a pdf file attachement or from my stored files. message reads : This file does not h...

1 reply Last reply on 8 Oct 2015 by
kieferschild

Conditional formating a column

 Solved

Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...

2 replies Last reply on 8 Oct 2015 by
Ian

Find words within cell & put value in adjacent

Column has Organisation Name Need to Search and Create a category to the next 5 columns A Organisation can have key word in more than 1 category...

1 reply Last reply on 8 Oct 2015 by
Mazzaropi

Help request - for advanced filter macro vba

Hello, I would like to have data from my master sheet to another one based on multiple criteria filter. My master sheet can be manually filled and ...

4 replies Last reply on 8 Oct 2015 by
evergreenX

Copy cells based on conditions

 Solved

Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...

2 replies Last reply on 8 Oct 2015 by
pefler

Pdf image recovery from corrupt pdf files

The pdf file in which i kept my pictures gt corrupt. i used image extractor tools but for nothing. please help me. i am clueless what to do?

2 replies Last reply on 8 Oct 2015 by
dwayne11

Vba macro to color a range of cells based on value of other cell

Hello, I' am using a shared file and hence could not use conditional formatting. I want range C2:F2 should turn Blue is the value in cell G2 is...

3 replies Last reply on 7 Oct 2015 by
rizvisa1

Automate some of my daily activity in excel using excel macros

Hello, I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I wo...

3 replies Last reply on 7 Oct 2015 by
ac3mark

Copying data from workbook to workbook using button

 Solved

Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...

4 replies Last reply on 7 Oct 2015 by
ac3mark

Stopped uploading my emails

Hello, Within the last few days my emails stopped coming into Outlook. I went to my Account Settings and redid them about 4 times. After doing i...

3 replies Last reply on 7 Oct 2015 by
ac3mark

Change color to different cells based on another cells text.

 Solved

Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...

4 replies Last reply on 7 Oct 2015 by
Riggs2015

Auto notify or mail when excel sheet updated. [solved/closed]

Hello, I have used following VBA, but still I am not getting the solution. Please help I am unable to change the following field. answer = M...

1 reply Last reply on 7 Oct 2015 by
rizvisa1

Unable to get email notifciation

Hello, I have placed below noted in my excel. but I am unable to get the email to my ID. Please help me Private Sub Workbook_BeforeSave(ByVa...

3 replies Last reply on 7 Oct 2015 by
rizvisa1

Excel workbook

Hello, I have a workbook with over 100 sheets. One of the sheets has a title of labels, I am trying to set it up ina way that if i type in sheet 10,...

1 reply Last reply on 7 Oct 2015 by
rizvisa1

Copy cell, unless another call says specific text

Hello, In my spreadsheet, currently C1 copies the number in A1. (=A1) I need this command to be overridden if B1 contains the text VISUAL Tha...

3 replies Last reply on 7 Oct 2015 by
rizvisa1

Copy row and insert n times

 Solved/Closed

Hello, I have an example below, I'd like to take the first row, copy it "n" number of times, then take the next row copy it the same "n" number of ti...

Last reply on 7 Oct 2015 by
sandy

Compare two worksheets and remove duplicated data from one

 Solved

Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...

3 replies Last reply on 6 Oct 2015 by
fillup56

Search for matches from columns on separate sheets.

 Solved

Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...

2 replies Last reply on 6 Oct 2015 by
Tim

Adding days to an auto populated date in excel

Hello, I want to add 3 business days to a auto populated date in another field. So for example. B1 will have the auto date (Based on a system ent...

6 replies Last reply on 6 Oct 2015 by
ysantana

Macro help required

Hi, If anyone can help me to create the excel macro on- I have 12 rows data in excel with cell position A to BT. My requirement is- I want to copy ...

1 reply Last reply on 6 Oct 2015 by
rizvisa1

Help please, vba userform, msgbox!

Hello. I have a userform that I use to introduce some data on excel. Most of the data must be filled (that are textbox that the verifications d...

1 reply Last reply on 6 Oct 2015 by
rizvisa1

Excel formula using julian calendar

Hello, Can someone please help me create a formula in excel to convert A16612009 to 6/15/2015. The letter A stands for the year 2015, 166 stands ...

1 reply Last reply on 6 Oct 2015 by
rizvisa1

How to lock/unlock a workbook with multiple passwords

Hello, I would like to lock/unlock a work book with multiple passwords. I would also like to add a Log tab and have the unlock record the user, d...

1 reply Last reply on 6 Oct 2015 by
rizvisa1

How to use macro to copy data from workfile a to workfile b

Hi, COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :- Source data copy from:-...

2 replies Last reply on 6 Oct 2015 by
Sad

Macro to transfer data from single to multiple columns

So I have been doing research but have been unable to find a macro that does what I need. Basically, I have multiple items on different carts, labeled...

1 reply Last reply on 6 Oct 2015 by
TrowaD

Display a new entry in a column in a separate cell in excel

Hello, I am having a column; A B 1 ab 2 abc 3 abcd 4 abcde 5 xyz 6 I want the next entry in 6 row of A to ...

1 reply Last reply on 5 Oct 2015 by
TrowaD

Converting number into alphabetic word

Kindly help in converting this 1,055.25 into alphabetic word... Thanks, Melvin Manila, Philippines

1 reply Last reply on 5 Oct 2015 by
TrowaD

Whole numbers and decimals

Forgive me if I was an anonymous user who had only a single question to ask after searching the internet for hours, and didn't know there were courtes...

1 reply Last reply on 5 Oct 2015 by
Mazzaropi

Create automatic tabs by sales rep

I have this information on one single tab (50 sales reps) Colum A - Sales Reps Colum B Revenue sold I need to create a single worksheet for each ...

1 reply Last reply on 2 Oct 2015 by
ac3mark

Date formatting

Hi, When I fetch raw data from a portal, the date comes in this text format Oct-02-2015. I make it in proper format 02-Oct-2015 through delimited a...

1 reply Last reply on 2 Oct 2015 by
Mazzaropi

If blank cell value of 1 + add 9 cells together

Hello, I need a formula where if the cell is blank it gets a value of 1, then I need it to add 9 cells together (in the same row). If something (te...

1 reply Last reply on 2 Oct 2015 by
Mazzaropi

Finding customers names

Hi i am struggling to find my customers names on Excel Spreadsheets i have tried the format box and used the find box i also tried the name box can so...

1 reply Last reply on 1 Oct 2015 by
RayH

Greater than and less than

Hello, i need help. A4 is the input i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any sug...

1 reply Last reply on 1 Oct 2015 by
RayH

How to copy data between several sheets on vba

 Solved

Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...

7 replies Last reply on 1 Oct 2015 by
TrowaD

Microsoft office unreadable documents

HELLO my laptop has a problem after i write a document i can't change in different styles that means it will results in unreadable and can't read b...

1 reply Last reply on 30 Sep 2015 by
Aziz

Values from one workbook to another

 Solved

Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...

2 replies Last reply on 30 Sep 2015 by
charms72

I am unable to send out hotmail from ms outlook

 Solved

Hello, I have configured two email address in outlook 2007. one gmail another one is hotmail. I can send email by my first one gmail account but I...

1 reply Last reply on 29 Sep 2015 by
ac3mark

Giving false with certain answers

 Solved

Hello, I am having an issue with my formula. Certain values will give me the correct answer (A, B, C, D, F) but other values will give me a FALSE...

1 reply Last reply on 29 Sep 2015 by
TrowaD
Results 2701 - 2750 out of a total of 12,266