| I am seek for powerful program for SEO!!! |
|
 |
Index ‹ Excel ‹ Excel Programming
|
- Previous
- 1
- Excel Misc >> Rounding numbers so that they are divisable by 31 B C
2 Original figure Annual Increase
divisible by 3
3 2.25%
£ 15,441.00 £15,788.4225
I want C3 to read £15789.00 as it is the nearest number to £15788.4225 that
is divisible by 3
The formula i used in C3 is =B3+($C$2*B3)
How can i amend this formula to ensure that my figure is divisable by 3
--
Thank you for reading my post. Hopefully you can answer my querie
- 2
- Excel >> Lookup Formula HelpHi
I have a formula that returns a blank when a zero is in place
=IF(A15>0,VLOOKUP(A15,'New Labour Standards'!$B$6:$C$990,2,FALSE)," ")
I want this also to return blank when a text entry is in place.
Please could you help.
Thanks
Brian
- 3
- 4
- Excel >> CSV Dates Not SortingThe CSV column that is in issue is filled with dates and nulls. It is an
exported list from a software program we use.
When you open the CSV file with Excel and it automatically converts, it sets
the date fields type as General. Even after you change the field to a date
from General, it still does not reconginize it as a date field. It gets
!value errors when using =Year() and it does not sort by date it sorts
alphanumerically.
Current Workaround:
If you change the filename extension to XLS so it doesn't auto convert the
CSV, you have the option to do the "text to columns" button. With this, you
can specify each column and mark the date columns as dates. When the
conversion completes you can use Year() and sort by date properly.
Is there any easier way to fix this problem so I don't have to teach people
how to use "text to columns"? Ideally, I want them to be able to just click
on the CSV file and not have them do anything technical.
Thanks,
- 5
- Excel Misc >> ACTIVATING FORMULA BAR SHORTCUTI have alot of data to modify in a worksheet. When I
finish one cell I hit enter to drop down to the next cell.
To edit the next cell I must use the mouse to go to the
formula bar to get in edit mode. Is there a way to do
this without touching the mouse?
- 6
- Excel Programming >> Using sheet names in menus etcI have a multi-sheet workbook in which some of the sheet names may be changed
by the user from time to time. I would like to be able to have these
worksheet name changes reflected automatically in the Chart Titles and in the
'Name' property of Custom menu items.
Is there any way this can be done please?
- 7
- Excel Programming >> copy non-contu.data into new sheeti have a created a Invoice in sheet1. Where i have used
vlookup function to lookup values from sheet2.
i want to create a Register for all the Invoice which i
print. I just want to copy some data from Invoice sheet
i.e. Cell a4,d7,e14,a10. (i.e. Date, Name,Ref. no., Amt)
When i print a invoice i should ask me do you want to
transfer data into sheet3, if yes than it should copy
above cell into sheet3 and print the invoice other wise i
should print invoice with out copy cell. It should copy
new data into next row when new invoice is print.
I try to copy data but it goto same row only. the copy is
like
Sub copydate()
Worksheets("Sheet1").Range("A1").Copy _
Destination:=Worksheets("Sheet2").Range("A2")
Worksheets("Sheet1").Range("D4").Copy _
Destination:=Worksheets("Sheet2").Range("B2")
Worksheets("Sheet1").Range("A10").Copy _
Destination:=Worksheets("Sheet2").Range("C2")
Worksheets("Sheet1").Range("E14").Copy _
Destination:=Worksheets("Sheet2").Range("D2")
End Sub
plz help me to work out this problem.
Shital Shah
- 8
- worksheet functions >> combined HLOOKUP (urgent for a friend)Hi!
given the table
2007 2008 2008 2009 2012
10% 20% 40% 35% 10%
I want to calculate the sum of the values in row 2 for a certain year, e.g.
2008. How to do if a certain value is shown more than once?
e.g.
if given 2008,
result = 60%
HLOOKUP returns only one value (the same applies to the MATCH function)
any solution???
thanks!
tom
- 9
- Excel Programming >> Conditional Information on PrintingI am new to VBA and was wondering if there is a way to selectively prin
information depending on what else is on the page. I have created a
excel spreadsheet which draws information from another application
formatting column headings with sample numbers and row headings wit
analysis titles. The results data prints in appropriate cell
depending on sample number and analysis. Sample comments print at th
bottom of the page. If sample number 1,2 4 and 6 print on the firs
page then I only want to print comments for these four sample number
on page one. If samples 7,10,12 and 14 print on page two then I onl
want to print comments for these samples on page two. Is there an
way to program cells in the BeforePrint depending on what appears o
the page being printed
--
Message posted from http://www.ExcelForum.com
- 10
- Excel Programming >> Textbox formattingHey guys,
I still cannot get a $ sign to come up before everything I type in a
textbox.
I want to be able to type in lets say TextBox1 and when I do, the $ sign
pops up in front of the number. I need the dollar sign to always be there
no matter how many times I re-enter numbers and I need it to format the cell
as $0.00
- 11
- Excel >> delay on copyhello and good new year
i have this problem : when i do a copy with ctrl+C or right clik and copy
after a full col selection of data ( col A B C D and line 1 to 64000 with
data) i have a delay of 30 second.
I have a lot of ram, disk capacity, a good processor. And i have no macro a
starting.
i'm on w2k wtih office 2003.
thank for your help.
- 12
- Excel Programming >> RPC Server UnavailableI have made a macro in VBe (Excel) to extract data from MSProject to
Excel
This runs the first time without any problems.
But if I want to run it again, it does not work.
I will get an error code with "RPC server unavailable".
After operating the reset button (in VBE) I can run the macro again.
I have tried the Reset command but this did not work.
Can anybody please advice me what I can do to overcome this problem.
Marcus
- 13
- worksheet functions >> I want to count days between two dates including start dateHi people - I count myself as a bit of a novice - so sorry if this is really
dumb! I have had a look on line and can see some similar looking enquiries -
except those want to do more complicated things than me. I simply want to put
two dates into two cells on the same row and count the number of working days
(Mon-Fri) including both start and end date.
e.g. at the moment if put in 20/06/07 - 25/06/07 it returns the value of -5
-when I want it to return a value of -6 (+2 for the weekend)= -4
Thanks for your help folks
Darren
Farnborough UK
- 14
- Excel Programming >> how to Interrupt text to speech run from wordI have followed the instructions here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;287120
to make a word macro which reads text aloud. This is great because unlike
Excel, it can read while you switch windows. The problem is that if you have
it reading a giant block of text, I can't find a way to get it to stop
without going to task manager and shutting the program down.
Is there some code I can add in that will allow me to stop it?
-------------
the VB is:
Sub TTS()
'Declare and create an Excel object.
Dim XL_tts As Excel.Application
Set XL_tts = CreateObject("Excel.Application")
XL_tts.Speech.Speak Selection
XL_tts.Quit
Set XL_tts = Nothing
End Sub
- 15
- Excel Programming >> Help: weild checkbox problemHello,
I have a sub which draws checkbox dynamicly. Most of the time it worked
fine. However, from time to time, the checkbox object name will not be
changed as instructed in the code. But if I run the sub again, the
problem will go away. Any ideas what is wrong?
Thank you very much.
------------------------------------------------------------
Sub drawCheckBox(nYears As Integer)
'This sub is used to dynamically draw checkBox in the DashBoard sheet
'
'
Dim i As Integer
Dim j As Integer
Dim leftCB As Integer
Dim topCB As Integer
Dim widthCB As Integer
Dim heightCB As Integer
Dim checkBoxName As String
Dim obj As OLEObject
Dim tempCB As OLEObject
For Each obj In Worksheets("DashBoard").OLEObjects
If obj.Name Like "CheckBox*" Then
'obj.Object.Value = False
obj.Object.Value = True ' this step is to unhide any hidden column
to avoid error
obj.Delete
End If
Next obj
widthCB = 67.5
heightCB = 15.75
topCB = 0
For i = 0 To nYears
If i < 6 Then leftCB = 500
If i >= 6 And i < 12 Then leftCB = 500 + widthCB
If i >= 12 And i < 18 Then leftCB = 500 + 2 * widthCB
checkBoxName = "CheckBox" & Year(Now()) - i
j = i Mod 6
'topCB = 329.5 + j * heightCB
topCB = 325.5 + j * heightCB
Set tempCB =
Worksheets("DashBoard").OLEObjects.Add(ClassType:="Forms.CheckBox.1",
Link:=False, _
DisplayAsIcon:=False, Left:=leftCB, Top:=topCB,
Width:=widthCB, Height:= _
heightCB)
tempCB.Name = checkBoxName
'Worksheets("DashBoard").OLEObjects(checkBoxName).Object.Value =
False
Worksheets("DashBoard").OLEObjects(checkBoxName).Object.Value =
True
Worksheets("DashBoard").OLEObjects(checkBoxName).Object.Caption =
"Year " & Year(Now()) - i
Worksheets("DashBoard").OLEObjects(checkBoxName).Object.BackColor =
&HC0FFC0
Next i
End Sub
--
huangx06
------------------------------------------------------------------------
huangx06's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25014
View this thread: http://www.excelforum.com/showthread.php?threadid=385420
|
| Author |
Message |
erinattbt123
|
Excel Programming >> I am seek for powerful program for SEO!!!
Give me link to SEO software (promotion, advertisement, etc.). I'
need it to promote my new e-shop.
Thanks
-----------------------------------------------------------------------
AbraahamLcn's profile: http://www.exceljockeys.com/forums/profile.php?mode=viewprofile&u=1
View this thread: http://www.exceljockeys.com/forums/viewtopic.php?t=32579
Excel201
|
| |
|
| |
 |
| |
|
Index ‹ Excel ‹ Excel Programming |
- Next
- 1
- worksheet functions >> Help - my toolbars have disappearedI am looking for some help again. In excel, I opened a file which once
closed seems to have distorted the toolbars on excel. When I look in
tools customise, "standard" and "formatting" seem to have disappeared.
Does anyone know how I can get them back ? (If I try to create new
ones, it says that they already exist, even though I cannot find
them).
Thanks for your help.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
- 2
- Excel Programming >> I want a non-blank cell to return 25% in an adjacent cell.Spreadsheet keeps track of steps to be completed in a phase of a project. As
each step is complete I want the system to return the % that step worth (1
out of 4 = 25%). I will total each % of each step complete to give me a
total of the phase completed. How do I create a formula for each step of the
phase that will return the %? I thought this should be as simple as saying:
IF C5 is not blank, return 25% (in cell D5). Please help.
Thank-you.
- 3
- Excel Misc >> Changing upper case characters to upper/lowerI have a file of names and addresses that were entered in all upper case. Is
> there a fast way to change this file into upper and lower case? Thanks for
> any help you can give me. I have read some of the former answers regarding this and they refer to use of macro's....I a novice user and need more guidance
- 4
- worksheet functions >> Table array in VLOOKUP (EXcel 2003)Hi
I use the VLOOKUP formula: =VLOOKUP(C21;PALIER;2) in which PALIER is a table
array and it works. I want now to have the "PALIER" changed by getting it
from another cell: =VLOOKUP(C21;C22;2) => i wrote "PALIER" in cell C22....
and that does not work anymore.
Is it a format issue , a table array issue or a Vlookup issue ?
Thanks.
jerome
- 5
- Excel Programming >> enable spell checkI created a form using excel and protected it so user's
can only input data were needed, but because i protected
the sheet, spell check doesnt work.
how can i enable spell check on a protected excel sheet?
- 6
- worksheet functions >> Linear regression errorsHi,
I have a set of data. When I graph the data on a scatter
plot and add a linear trendline, I also get an equation of
the line along with R2. However, when I use the worksheet
functions CORREL SLOPE and INTERCEPT I get different
values than the ones on the graph. Why? Please post back
Thanks,
Mike S.
- 7
- 8
- worksheet functions >> Counting Dates - Not TextHi,
I'm trying to count the number of "date" occurrences on a particular month.
However in the same column, aside from dates, there are TEXT entries and
blank cells.
When I use the formula below it gives me a #VALUE!
Please edit the formula below so I can count the number of date occurences.
=SUMPRODUCT(--(MONTH('Date'!J2:J1116)=1))
Thank you.
- 9
- Excel Programming >> How can I pass an array as TextToDisplay to a hyperlink?I have a procedure that searches through every sheet (108) in a
workbook for matching data then puts a hyperlink to those data onto a
"Hyperlog" worksheet.
here's part of the code
Option Explicit
Option Base 1
Dim hlText(3) as String
Dim rte as string
Dim num as string
Dim street as string
Dim r as Integer
Dim foundNum as Range
.
.
.
r = 3
hlTarget:=foundNum 'result of Find"
a do loop here as long as matches are being found
hlText(1) = rte: hlText(2) = num: hlText(3) = street
Sheets("HyperLog").Hyperlinks.Add Anchor:=Cells(r, 1), _
Address:="", SubAddress:=rte & "!" & hlTarget, TextToDisplay:=hlText()
If I use hlText() or hlText, I get invalid argument error.
If I use hlText(3) only the 3rd element is passed
hlText(1) & hlText(2) & hlText(3) works except when executing the
hyperlink
Private Sub Workbook_SheetFollowHyperlink(ByVal Sh As Object, ByVal
Target As Hyperlink)
CenterOnCell Range Target.SubAddress, Target.TextToDisplay
End Sub
fails at .TextToDisplay
What do I do now coach?
Jay
- 10
- 11
- 12
- Excel Programming >> Organizing functionsGood afternoon everyone,
I've got more of a style question than technical one this time around. I'm
currently assembling all my custom functions and subs into one project. I
have been collecting some over the last couple of projects I've done, so I
thought it might be a good idea to have the ones I use very often together.
I am currently on 50-60 of them. The thing is that I've read so many
different opinions about how to store them.
Should I group them in different modules, or should I just create one big
module and comment every sub I have? Is there a processing-time difference
of having let's say 10 different modules or just having one big one?
Second question: should I save it as an add-in or would you recommend me
saving it as a normal spreadsheet?
I'd appreciate any comment on this matter.
Thanks guys ;o)
kj
- 13
- Excel Programming >> Retrieven data from closed workbooks - Ron de BruinI am using Ron's code to retrieve data from closed workbooks.
The code works wonderful but I need to transpose the output on the
destination book because I am copying a complete column from each workbook
and I want to have the name of the book as the title.
Instead of
e.g. Range1 Book1
Range2 Book2
Range3 Book3
I need it:
Book1................ Book2 ................. Book3
Range1(ColumnC) Range2(ColumnC) Range3(ColumnC) ETC.
Thanks in advance for the help!
- 14
- Excel Programming >> Help with Check Box and VBAHi,
I am new to excel and I am not sure if what I want is doable or not,
would really appreciate your help;
I want to create a two columns sheet in the first column I want a chec
box in the next column a date field. When the user checks the check bo
the current date and time would be put in the date column this way
can tell when that task was done. If the check mark is unchecked th
second cell needs to be cleared out if a date was there already.
If you can help me with both how to create the check box and how t
attach the code to it to do the above it will be great.
Thanks
--
Message posted from http://www.ExcelForum.com
- 15
- Excel Programming >> How can I check if a pop-up menu exists...Hi All,
Help with another (probably easy for you all) question. I use the code
below to add a pop-up menu that runs a macro.
On Error Resume Next
With Application
.CommandBars("Cell").Controls("GICAP Formatter").Delete
Set cBut = .CommandBars("Cell").Controls.Add(Temporary:=False)
End With
With cBut
.Caption = "GICAP Formatter"
.Style = msoButtonCaption
.OnAction = "FormatIssuesWorkSheet"
End With
What I need to know is how to check if the pop-up menu exists the next
time the workbook is opened? The "on error" process doesn't work for me
in this case because I need this check in the middle of a subroutine.
However, I continue in the subroutine whether it exists or not.
Can someone help?
Thanks,
Chris
|
|
|