Hi,
I'm sure there is an easy answer to this but I'm not getting it. I have two cells (A1 and B1) with percentages in them. The percentages should always equal 100%. I do a sum of A1 thru B1 and place the results into cell C1. I then thought I could use Data Validation in Excel 2007 to make sure the value of C1 always equals 1.0. But Data Validation only seems to work on cells where data is input from the user.
How can I easily test cell C1 to see if its always 100% and if its not, put out an error message to user telling them that the two values in cells A1 and B1 should equal 100% when typing in numbers.
Thank you in advance.
Steve
Hi all,
I have data list whose names are not in consistent format.
I am looking for excel tips which helps in name normalization.
i know it is not cent 100% accurate but any excel tips which reduces manual normalisation process is very helpful.
i am using excel 2007.
Thanks in advance.
Here is small sample set
Sheet2
B
C
1
Raw data
Normalised
2
zata ltd
zata
3
zATA LIMITED
zata
4
zata L T D
zata
5
VR GROUP
VR GROUP
6
V R GROUP
VR GROUP
7
ENFOY TECHNOLOGIES
ENFOY
8
ENFOY TECH
ENFOY
9
FIRST FORCE SA
FIRST FORCE
10
FIRST FORCE SRL
FIRST FORCE
11
FIRST FORCE OYA
FIRST FORCE
12
FIRST FORCE INTERNATION
FIRST FORCE
13
FIRST FORCE INTL
FIRST FORCE
14
PHK ENGINERING
PHK ENGINERING
15
P H K ENGINERING
PHK ENGINERING
Got 13,000 lines of data trying to run a forumla and it keeps freezing when I hit F9.
Left it running 30 mins and it still didnt unfreeze.
Any tips on crunching large amounts of data?
Here's a few web links to some useful information:
An Introduction to Spreadsheets
Jan's Excel Spreadsheet Design
Overview of Spreadsheets
If you have more, please add to this list.
42!
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
I am just learning Excel,I hope to start with Data Entry job..Pleae give Tips on what things I need to learn the most.
I have textbox's for data entry though you can do anything as simple as hitting enter to go down to the next line.
Anyone have some examples or tips on how to beef them up a bit?
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
