Hi All,
Looking forward to your reponses.
Rgds,
Bharghav Ramdas
On Tue, May 24, 2011 at 9:57 AM, Bharghav Ramdas wrote:
> Hi All,
>
> I am currently working on an excel (2003)sheet whose cell character length
> is beyond 255. I am able to copy just 255 characters. The remaining
> characters get
Hi,
You can select all the dates and use Control + H
Find What: 2011
Replace With: 2010
then click on Replace All button. It will change all the 2011 to 2010
Hope this helps!
Thanks,
Shreedar
On Thu, May 26, 2011 at 11:19 PM, Rich Prince wrote:
> I have a column of various dates that have the
Assuming that you r date is in Cell A1
Convert them with this formula:
Formula in B1=Date(2010,Month(A1),Day(A1))
On Fri, May 27, 2011 at 12:49 AM, Rich Prince wrote:
> I have a column of various dates that have the incorrect year, for
> example:
>
> 9/1/2011
> 12/17/2011
> 10/31/2011
>
I don't know if this is possible but I am hoping so. I run several
performance reports daily and weekly. On Monday's I have to run the
reports twice, once to compile the prior week recap and the second
time to produce the current weeks performance. Currently between runs,
I have to archive the prio
I have a column of various dates that have the incorrect year, for
example:
9/1/2011
12/17/2011
10/31/2011
etc, etc...
The year should be 2010 not 2011. Is there a quick remedy to correct
this problem for several hundred dates? The Month and day are correct
- just not the year.
Any ideas?
--
Thanks but i was able to send the mails i just missed it so i thought its not
getting delivered. thanks anyways :)
- Original Message
> From: JsinSk
> To: MS EXCEL AND VBA MACROS
> Sent: Thu, 26 May, 2011 12:41:26 PM
> Subject: $$Excel-Macros$$ Re: Test Mail
>
> When you reply to a
When you reply to a post the moderators must approve it before it will
appear. The delay in your reply and when it shows varies.
On May 25, 3:16 pm, hanumant shinde wrote:
> just checking if i can send a mail or not. i had sent a reply to 1 post but i
> cant see my reply. i dot know whats wrong.
Hi Ashish,
Thank you for your reply. I am not getting desired ouput i.e. in ur macro I
am getting grade 3 employee count, but I need full details of that grade 3
employees. I need result such that if we double click on pivot item 3 we get
those records in a new sheet. just like that I want the res
thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: Wednesday, May 25, 2011 7:18 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to filter only the required information using
VBA codes?
hi
check the attachment
You have to open up Visual Basic from toolbar and paste in Ashish's coding
in the module. Then save.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jeannie
Sent: Wednesday, May 25, 2011 8:30 AM
To: MS EXCEL AND VBA MACROS
Subject
just checking if i can send a mail or not. i had sent a reply to 1 post but i
cant see my reply. i dot know whats wrong.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
I have a set of columms, each containing formulas. I want to loop
through these and fill down each time. This is what I have at present:
Sub fillRecon()
Dim MY_COLUMN As Integer
LastRow = limit ' formula finding the number of rows in a
worksheet.
workBookS("Sample.xls").Sheets("RESULT
12 matches
Mail list logo