 news.only-4-geeks.com Forum Index » Excel | Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 Next |
|  | macro | | |
| | | server |  |
|  Posted: Mon May 26, 2008 8:56 am Post subject: macro |  |
| |
| | | JB | |
| | Posted: Mon May 26, 2008 8:56 am Post subject: Re: macro | |
| |  | |
Thank you for your help
Sorry but I'm very basic in this. Where do I put it? do I add it to the
macro or redo it?
Ta
"AndrewArmstrong" <a.armstrong11@comcast.net> wrote in message
news:874071a7-49e2-4028-92f6-e398c7023b9a@m44g2000hsc.googlegroups.com...
| Quote: | On May 22, 5:02 pm, "JB" <somehow@somewhere> wrote:
Hello
I have created a spreadsheet for filling in details in a section and I
want
the user to input the data as and when it's needed. It contains the
field
headers to guide the user to fill-in the correct data)
I created a macro to copy the section of the spreadsheet i.e. rows 3 to
10
and paste them below, which would be from 11 onwards. but I want to be
able
to run the macro again but paste the section below the last one that was
pasted.
When I run it, it pastes over the first section I pasted when recording
the
macro. In other words, how do I do it so that it targets the next empty
row
after the last section?.
I hope that makes sense
Excel 2003
Use something like this in your code, where your data would be in
columns A to Z
dim lnglastrow as long
lnglastrow=Range("a65536:z65536").end(xlup).row
range("a"&lnglastrow).select |
|
| |
| | | Mais qui est Paul | |
| | Posted: Mon May 26, 2008 9:40 am Post subject: Re: Compare Now() to a European date | |
Bonsour® Lars avec ferveur ;o))) vous nous disiez :
| Quote: | This is driving me nuts,
;o)))
I have a list of certificates. In column B their expiry dates are
entered as Europeans, some at least, do. Like today would be 20080524.
I want these cells to change colour with conditional formating.
For instance becoming yellow when there is less than three months
between now and the expiry date, and then becoming red when there
is less than one month to expiry. Else they should remain without
colour.
|
I supppose column "B" format is Standard
Select (Format > Conditional Formatting) to display the Conditional Formatting dialog box.
Condition 1
Select "Formula Is" in the first drop-down box and enter the formula
=TODAY() < DATE(INT(B1 / 10000) , 3 + MOD(INT(B1 / 100) , 100) , MOD(B1 , 100))
Click the Format button to apply your specific formatting
HTH
--
@+
;o))) |
| |
| | | SD | |
| | Posted: Mon May 26, 2008 9:43 am Post subject: Re: Pivot | |
On May 23, 11:40 pm, "Bernie Deitrick" <deitbe @ consumer dot org>
wrote:
| Quote: | Saurabh,
Sounds like you pasted text values over your number values. Try entering 1 into a blank cell,
copying that cell, then selecting the data cells and using Paste Special Multiply. That will
convert any text values to numbers.
|
Thanks Bernie for the help, however I did try to get this done, and
it did not work just cant get the Pivot listed item. May be I redo
the whole thing over , however if there is anything else you would
want me to try I could .. thanks SD |
| |
| | | Lars | |
| | Posted: Mon May 26, 2008 11:24 am Post subject: Re: Compare Now() to a European date | |
| | | |
Previously, on Usenet "Mais qui est Paul" <Excel-addict@mpfe.fr>
wrote:
Bonsour Paul,
I am afraid Excel did not accept that as a valid formula at all. And
it pointed towards the commas (,), so I replaced them with ; and then
it was accepted, but did not produce any color according to my
conditional format settings.
I already had 20080606 in that cell, formatted as "general". What is
even worse though is that when I entered another date, on the same
format, into that cell, all I get in return is that dreaded ##### and
the message that negative dates are displayed as #####.
| Quote: | Select "Formula Is" in the first drop-down box and enter the formula
=TODAY() < DATE(INT(B1 / 10000) , 3 + MOD(INT(B1 / 100) , 100) , MOD(B1 , 100))
Click the Format button to apply your specific formatting
|
I have also tried the other suggestions given here yesterday by Bob
Phillips. It does not do anything at all as far as I can see. I must
admit that I understand little of the VBA code, but I am quite used to
debugging macros by stepping through them in the VBA-editor.
Maybe I should have mentioned already from the beginning that I have
XP SP2, english, and Office 2003 SP3, english. My regional options
though are set for Sweden and Swedish.
Lars
Stockholm |
| |
| | | user | |
| | Posted: Mon May 26, 2008 12:08 pm Post subject: Re: export MySQL to Excel? | |
| | | |
On Sun, 25 May 2008 19:28:43 +0100, Geoff Cox wrote:
| Quote: | Hello,
I have an on-line MySQL database and wish to have a table in it
available for Excel.
I can use some php to get the data and then put it into Word and edit
the file to put each record onto a new line and then open the text file
in Excel.
Is there an easier way?!
Cheers
Geoff
PS the php was taken from the net and has the code below and includes
...
|
Hi -
You point out that you cannot make sense of the bit after the '//'.
That's a comment that hints at how to get your files in Excel format,
instead of Word format.
Work through the code both directions until you discover where $w is
equated to 'isset'. There should/will be either an opposite of 'isset'
along with a way to equate that value to $w OR a way to just NOT equate
'isset' to $w (impliedly setting the opposite condition).
That is all on the client side, so you should be able to make the
changes, or find individual who can/will.
HTH |
| |
| | | Ron de Bruin | |
| | Posted: Mon May 26, 2008 1:25 pm Post subject: Re: Attaching Chart to Email? | |
Hi CWLee
Try this example
LINK
--
Regards Ron de Bruin
LINK
"CWLee" <cdubyalee@post.harvard.edu> wrote in message news:e49TyIvvIHA.3760@TK2MSFTNGP04.phx.gbl...
| Quote: |
I have an Excel spreadsheet, and derived from it 5 charts.
How can I attach one of the charts to an email to send to
someone?
(I know how to attach the whole spreadsheet, and the
associated charts, but I don't want to send the spreadsheet
and the other 4 charts, because they contain data not
appropriate to share with the email recipient.)
Thanks.
--
----------
CWLee
Former slayer of dragons; practice now limited to sacred
cows. Believing we should hire for quality, not quotas, and
promote for performance, not preferences.
|
|
| |
| | | lukus2005@gmail.com | |
| | Posted: Mon May 26, 2008 1:40 pm Post subject: Re: VLOOKUP using a list not in alphabetical order. | |
| | | |
On May 23, 12:08 pm, Pete_UK <pashu...@auditel.net> wrote:
| Quote: | VLOOKUP has a 4th (optional) parameter which if missing defaults to
TRUE (or 1) meaning that the lookup table needs to be sorted. However,
if it is set to FALSE (or 0) then the table does not need to be
sorted, and VLOOKUP looks for an exact match. I think this is what you
need to use.
Hope this helps.
Pete
On May 23, 4:53 pm, "lukus2...@gmail.com" <lukus2...@gmail.com> wrote:
I want to create a pulldown list to select various material based on
size (ie: 1/2" x 1", 5/8" x 1", 3/4" x 1", etc...). I then want to
use VLOOKUP to find the associated price.
The problem is that my list of material is not in alphabetical order
as i want list them based on size therefore, 5/8" before 3/4" or 1"
but Excel put the 1" first, followed by 1/2", 3/4", and then 5/8".
I thought about adding a column in my list of material to number the
items in the order i want them listed. But how do i tell VLOOKUP to
look at the "position" returned in my pulldown selection instead of
the actually "text" selected.
In other words, if i select 3/4" x 1" in my pulldown list, and say for
example, that selection is the 9th item in my pulldown, i don't want
VLOOKUP to look for 3/4" x 1" in my list price but instead, I want
VLOOKUP to look for the 9th item on my price list.
Is a Data Validation list capable of returning the position # of the
item selected in the list? If so, what is the function to do so?
TIA
|
Thanks, that works! |
| |
| | | Mais qui est Paul | |
| | Posted: Mon May 26, 2008 2:45 pm Post subject: Re: Compare Now() to a European date | |
| | | |
Hej Lars gärna understryka min du berätta för oss:
| Quote: | I am afraid Excel did not accept that as a valid formula at all. And
it pointed towards the commas (,), so I replaced them with ; and then
it was accepted, but did not produce any color according to my
conditional format settings.
I already had 20080606 in that cell, formatted as "general". What is
even worse though is that when I entered another date, on the same
format, into that cell, all I get in return is that dreaded ##### and
the message that negative dates are displayed as #####.
Select "Formula Is" in the first drop-down box and enter the formula
=TODAY() > DATE(INT(B1 / 10000) , 3 + MOD(INT(B1 / 100) , 100) , MOD(B1 , 100))
Click the Format button to apply your specific formatting
XP SP2, english, and Office 2003 SP3, english. My regional options
though are set for Sweden and Swedish.
|
Perhaps you probably have to type the formula in swedish :
Kanske har du förmodligen att skriva formeln på svenska:
Välj "formel" i den första rullgardinsmenyn och skriv in formeln
=IDAG()>DATUM(HELTAL(A1/10000),3+REST(HELTAL(A1/100),100),REST(A1,100))
Klicka på Format-knappen för att tillämpa dina specifika formatering
Have a look at this sample :
Ta en titt på detta prov:
No Macro, No VBA
LINK
--
@+
Google är din vän
;o))) |
| |
| | | CWLee | |
| | Posted: Mon May 26, 2008 3:30 pm Post subject: Re: Attaching Chart to Email? | |
"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote
| Quote: | Try this example
LINK
|
Thanks, but I'm too unsophisticated to follow it. You lost
me after:
Dim OutApp As Object
Dim OutMail As Object
Dim Fname As String
....
Thanks again for responding.
Best regards to all. |
| |
| Page 1 of 20 .:. Goto page 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20 Next | |
|
|
