Re: $$Excel-Macros$$ journal entry
can you explain it in detail On Sun, Jul 31, 2011 at 11:34 AM, Ananta Sapkota sapkota.ana...@gmail.comwrote: I have attached file which gives us simple idea whatever i want to do. Please help me. It's urgent for me to keep accounting record. ananta Sapkota -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area
Can you attach the sample sheet On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova 9uzal.yusup...@gmail.comwrote: Is there any way to set up more than one filter in one sheet? Thank you! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column
HI, True enough ! Sorry, I just tested the first cell;-( Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Viswanathan M Envoyé : dimanche 31 juillet 2011 19:05 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column Dear Sir The formula given by Mr.Daniel is awesome but will give wrong results except for the first set. A slight modification as given below will bring out the intended result. =INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2=P,COLUMN($B2:$AE2 In the above formula, the second and the third ranges should be of mixed referencing. regards viswanathan m On Sun, Jul 31, 2011 at 5:50 PM, Daniel dcolarde...@free.fr wrote: Hi, In AF2 (array formula, validate with Ctrl+Shift+Enter) : =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2=P,COLUMN($B$2:$AE$2 Copy down. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de maulik desai Envoyé : dimanche 31 juillet 2011 10:26 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ How to Find Last Present Date From Month in One column Hi Group, Required Small help, I am having one excel sheet in that i have to update the Emp Attendance status for every month actul no of Emp are more then 500 I have to update their last Present date in Final column. (details given in Attached File) Currently i have to find out date manually its take long time to update. Request you to kindly provide the solution. -- Thanks Regards, Maulik Desai 9967363926 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- With warm regards Viswanathan M DE(Tech) RGM TTC Chennai-600027 mviswanat...@bsnl.co.in 94861 00423 Vande Mataram -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Need Formula
Hi Team, I have one sheet in which Two Columns are there in which first Column there is Employee id and employee name. In Second column i need the exact employee id as per there names. Hence pls tell me formula for the same. Please find the attached sheet for your Reference. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel New Microsoft Office Excel Worksheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Formula
hi jocky pfa. it may help. -- *Great day,* *viper * On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta jocky6...@gmail.com wrote: Hi Team, I have one sheet in which Two Columns are there in which first Column there is Employee id and employee name. In Second column i need the exact employee id as per there names. Hence pls tell me formula for the same. Please find the attached sheet for your Reference. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel solution.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Need Formula
Hi, Here is the solution. Thanks Regards, Nitesh Kandade Jr. Analyst OneWest Bank, FSB Office: (213) 337-3653 Ext.: 68361 nitesh.kand...@owb.commailto:nitesh.kand...@owb.com This message contains information which may be confidential and privileged. Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please let the sender know and delete the message. Thank you From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jocky Beta Sent: Monday, August 01, 2011 12:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Formula Hi Team, I have one sheet in which Two Columns are there in which first Column there is Employee id and employee name. In Second column i need the exact employee id as per there names. Hence pls tell me formula for the same. Please find the attached sheet for your Reference. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel lookup.xlsx Description: lookup.xlsx
RE: $$Excel-Macros$$ How to Find Last Present Date From Month in One column
See the attached File,
Hope it will help you .
{=MAX((A2:L2=P)*A1:L1)}
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: Monday, August 01, 2011 1:24 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ How to Find Last Present Date From Month in
One column
HI,
True enough ! Sorry, I just tested the first cell;-(
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Viswanathan M
Envoyé : dimanche 31 juillet 2011 19:05
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One
column
Dear Sir
The formula given by Mr.Daniel is awesome but will give wrong results except
for the first set. A slight modification as given below will bring out the
intended result.
=INDEX($A$1:$AE$1,1,MAX(IF($B2:$AE2=P,COLUMN($B2:$AE2
In the above formula, the second and the third ranges should be of mixed
referencing.
regards
viswanathan m
On Sun, Jul 31, 2011 at 5:50 PM, Daniel dcolarde...@free.fr wrote:
Hi,
In AF2 (array formula, validate with Ctrl+Shift+Enter) :
=INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2=P,COLUMN($B$2:$AE$2
Copy down.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de maulik desai
Envoyé : dimanche 31 juillet 2011 10:26
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ How to Find Last Present Date From Month in One
column
Hi Group,
Required Small help,
I am having one excel sheet in that i have to update the Emp Attendance
status for every month actul no of Emp are more then 500 I have to
update their last Present date in Final column. (details given in Attached
File)
Currently i have to find out date manually its take long time to update.
Request you to kindly provide the solution.
--
Thanks Regards,
Maulik Desai
9967363926
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
http://www.excel-macros.blogspot.com/
4. Learn VBA Macros at http://www.quickvba.blogspot.com
http://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
http://exceldailytip.blogspot.com/
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
http://www.excel-macros.blogspot.com/
4. Learn VBA Macros at http://www.quickvba.blogspot.com
http://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
http://exceldailytip.blogspot.com/
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
With warm regards
Viswanathan M
DE(Tech)
RGM TTC Chennai-600027
mviswanat...@bsnl.co.in
94861 00423
Vande Mataram
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
RE: $$Excel-Macros$$ Need Formula
See the attached FIle =SUM(($B$4:$B$20=E4)*$A$4:$A$20) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kandade, Nitesh Sent: Monday, August 01, 2011 1:37 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Need Formula Hi, Here is the solution. Thanks Regards, Nitesh Kandade Jr. Analyst OneWest Bank, FSB Office: (213) 337-3653 Ext.: 68361 nitesh.kand...@owb.com mailto:nitesh.kand...@owb.com This message contains information which may be confidential and privileged. Unless you are the addressee (or authorized to receive for the addressee), you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received the message in error, please let the sender know and delete the message. Thank you _ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jocky Beta Sent: Monday, August 01, 2011 12:46 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Formula Hi Team, I have one sheet in which Two Columns are there in which first Column there is Employee id and employee name. In Second column i need the exact employee id as per there names. Hence pls tell me formula for the same. Please find the attached sheet for your Reference. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of lookup.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula
Oops The below should read: Is A5 less than or equal to T5? - No - Go to the next statement Is A5 less than or equal to T6? - No - Go to the next statement Is A5 less than or equal to T7? - Yes - Stop. Answer: S7 Dave. From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula Date: Mon, 1 Aug 2011 12:50:31 +0800 Hi, Try this: =IF(A5=$T$5,$S$5,IF(A5=$T$6,$S$6,IF(A5=$T$7,$S$7,IF(A5=$T$8,$S$8,IF(A5=$T$9,$S$9,IF(A5=$T$10,$S$10,)) The multiple IF statement stops as soon as it finds a TRUE. So you don't need to use AND statements to create 'windows' The above asks: Is A5 greater or equal to T5? - No - Go to the next statement Is A5 greater or equal to T6? - No - Go to the next statement Is A5 greater or equal to T7? - Yes - Stop. Answer: S7 This could probably be easier done with VLOOKUP Regards - Dave. Date: Sun, 31 Jul 2011 17:50:12 -0700 Subject: $$Excel-Macros$$ $$Excel-Macro$$ - Optimize Formula From: velocity...@gmail.com To: excel-macros@googlegroups.com Any help in shortening or optimizing this formula would be great. Im limited by the nested if statements to match week numbers (column s) and week ended date (Column T), and continue to bog down the recalculations. It does work, but slows things down.I'm using it to determine if a date falls within a certain period in Column T =IF(A5=$T$5,$S$5,IF(AND(A5$T$5,A5=$T$6),$S$6,IF(AND(A5$T$6,A5=$T $7),$S$7,IF(AND(A5$T$7,A5=$T$8),$S$8,IF(AND(A5$T$8,A5=$T$9),$S $9,IF(AND(A5$T$9,A5=$T$10),$S$10,)) many thanks, Financeguy -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Remove HyperLink without Macro
Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C*. Please can u explain briefly regarding this. Thanks! On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance samde...@gmail.com wrote: Nice one XLS S On Jul 31, 10:41 am, XLS S xlst...@gmail.com wrote: Dear All, Try this 1. In a blank cell, enter the number 1. 2. Select the cell and press *Ctrl+C*. 3. Hold down the *Ctrl* key as you click each hyperlink you want to remove. 4. Right Click and Choose Paste Special from 5. Select the Multiply radio button (In Operations). 6. Click OK. All the hyperlinks are removed, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Dynamic Chart
Hi, I needed data for 12 weeks. In attached file I need chart for 30th - 41st week. If I enter 42nd week data I need chart from 31st - 42nd Week chart. Thanks in advance. On Fri, Jul 29, 2011 at 5:47 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *See the attached Workbook* * * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* Friday, July 29, 2011 7:29 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Dynamic Chart ** ** Hi, Can u pls help me in doing dynamic chart in attached file. I tried using formulas which is in attacthed file. But I could not able to do the same.* *** I need only 12 weeks data in the chart. Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Book1 (5).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area
Hi raj, Can you explain in detail .. i tried but i amnot getting Thanks On Mon, Aug 1, 2011 at 12:00 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Spilt Your Date in Multiple Table * *See the attached file if it helps* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashish koul *Sent:* Monday, August 01, 2011 11:44 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area** ** ** ** Can you attach the sample sheet On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova 9uzal.yusup...@gmail.com wrote: Is there any way to set up more than one filter in one sheet? Thank you! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/* http://akoul.posterous.com/* *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830*** * P Before printing, think about the environment. ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Dynamic Chart
See if it hels From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, August 01, 2011 3:32 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Dynamic Chart Hi, I needed data for 12 weeks. In attached file I need chart for 30th - 41st week. If I enter 42nd week data I need chart from 31st - 42nd Week chart. Thanks in advance. On Fri, Jul 29, 2011 at 5:47 PM, Rajan_Verma rajanverma1...@gmail.com wrote: See the attached Workbook From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, July 29, 2011 7:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic Chart Hi, Can u pls help me in doing dynamic chart in attached file. I tried using formulas which is in attacthed file. But I could not able to do the same. I need only 12 weeks data in the chart. Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of abcs.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Multiple filters in one spreadsheet area
We cant use AutoFilter on Multiple Row in A Single Sheet, If you want to Apply the Filter On Multiple Row , You have to Bifurcated your Data in to Separate Areas and then Convert them Used Area to Table , By Default ,Table Provides Automatic AutoFilter at The Heading Row, Hope I Could explain you .. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Monday, August 01, 2011 4:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area Hi raj, Can you explain in detail .. i tried but i amnot getting Thanks On Mon, Aug 1, 2011 at 12:00 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Spilt Your Date in Multiple Table See the attached file if it helps From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Monday, August 01, 2011 11:44 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area Can you attach the sample sheet On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova 9uzal.yusup...@gmail.com wrote: Is there any way to set up more than one filter in one sheet? Thank you! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.com http://akoul.posterous.com/ http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area
hi i got it thks On Mon, Aug 1, 2011 at 5:00 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *We cant use AutoFilter on Multiple Row in A Single Sheet, If you want to Apply the Filter On Multiple Row , You have to Bifurcated your Data in to Separate Areas and then Convert them Used Area to Table , By Default ,Table Provides Automatic AutoFilter at The Heading Row,* *Hope I Could explain you ..* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *vijayajith VA *Sent:* Monday, August 01, 2011 4:38 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area** ** ** ** Hi raj, ** ** Can you explain in detail .. i tried but i amnot getting ** ** Thanks On Mon, Aug 1, 2011 at 12:00 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Spilt Your Date in Multiple Table * *See the attached file if it helps* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashish koul *Sent:* Monday, August 01, 2011 11:44 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area** ** Can you attach the sample sheet On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova 9uzal.yusup...@gmail.com wrote: Is there any way to set up more than one filter in one sheet? Thank you! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/* http://akoul.posterous.com/* *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830*** * P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need Formula
Dear Jocky,
Please use below formula...it wll be useful in case of duplicacy..
See attached Sheet...
=IF(COUNTIF($E$4:E4,E4)1,VLOOKUP(E4,CHOOSE({1,2},$B$4:$B$20,$A$4:$A$20),2,1),VLOOKUP(E4,CHOOSE({1,2},$B$4:$B$20,$A$4:$A$20),2,0))
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I have one sheet in which Two Columns are there in which first Column
there is Employee id and employee name. In Second column i need the exact
employee id as per there names. Hence pls tell me formula for the same.
Please find the attached sheet for your Reference.
Regards,
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Solved.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ journal entry
I want to enter journal voucher from one sheet of excel. And data of relevant account type must be entry its exact sheet. On Mon, Aug 1, 2011 at 11:56 AM, ashish koul koul.ash...@gmail.com wrote: can you explain it in detail On Sun, Jul 31, 2011 at 11:34 AM, Ananta Sapkota sapkota.ana...@gmail.com wrote: I have attached file which gives us simple idea whatever i want to do. Please help me. It's urgent for me to keep accounting record. ananta Sapkota -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Remove HyperLink without Macro
Hey, In any blank cell enter any value like 1,2,3,name..then copy the cell...and hold ctrl buttonthen.select hyperlink (with hold ctrl button) cellsnow..just right click.paste special select Multiply (in operation) then enter. On Mon, Aug 1, 2011 at 3:33 PM, Neelakanta AB neelakanta...@gmail.comwrote: Hi Not able to work on the same format suggested. Share little more details for this it will be very helpful. Thanks! On Mon, Aug 1, 2011 at 3:27 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C*. Please can u explain briefly regarding this. Thanks! On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance samde...@gmail.com wrote: Nice one XLS S On Jul 31, 10:41 am, XLS S xlst...@gmail.com wrote: Dear All, Try this 1. In a blank cell, enter the number 1. 2. Select the cell and press *Ctrl+C*. 3. Hold down the *Ctrl* key as you click each hyperlink you want to remove. 4. Right Click and Choose Paste Special from 5. Select the Multiply radio button (In Operations). 6. Click OK. All the hyperlinks are removed, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Vba Code required to link every cell of workbook to another workbook
It will take a lot of time initially. If there is any code or formula then would be helpful very much. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Remove HyperLink without Macro
Hi, =TEXT(C3;1) - Here whats 1 stands for please let me know. Thanks On Mon, Aug 1, 2011 at 2:40 PM, XLS S xlst...@gmail.com wrote: Hey, In any blank cell enter any value like 1,2,3,name..then copy the cell...and hold ctrl buttonthen.select hyperlink (with hold ctrl button) cellsnow..just right click.paste special select Multiply (in operation) then enter. On Mon, Aug 1, 2011 at 3:33 PM, Neelakanta AB neelakanta...@gmail.comwrote: Hi Not able to work on the same format suggested. Share little more details for this it will be very helpful. Thanks! On Mon, Aug 1, 2011 at 3:27 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C*. Please can u explain briefly regarding this. Thanks! On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance samde...@gmail.com wrote: Nice one XLS S On Jul 31, 10:41 am, XLS S xlst...@gmail.com wrote: Dear All, Try this 1. In a blank cell, enter the number 1. 2. Select the cell and press *Ctrl+C*. 3. Hold down the *Ctrl* key as you click each hyperlink you want to remove. 4. Right Click and Choose Paste Special from 5. Select the Multiply radio button (In Operations). 6. Click OK. All the hyperlinks are removed, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Vba Code required to link every cell of workbook to another workbook
See the attached Sheet, Double click on Any Cell in Sheet1 it will activate that cell of Sheet2 Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim st As String Dim sh As Worksheet Set sh = Sheets(Sheet2) st = Target.Address sh.Activate sh.Range(st).Activate ActiveCell.Value = sh.Name st End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Monday, August 01, 2011 6:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vba Code required to link every cell of workbook to another workbook Hi All, Vba code required to link whole workbook (every cell of workbook) to another workbook. Regards, Kaushik -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book2.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need Formula
try this cell d4 =INDEX($A$3:$A$20,MATCH(E4,$B$3:$B$20,0)) On Mon, Aug 1, 2011 at 1:15 PM, jocky Beta jocky6...@gmail.com wrote: Hi Team, I have one sheet in which Two Columns are there in which first Column there is Employee id and employee name. In Second column i need the exact employee id as per there names. Hence pls tell me formula for the same. Please find the attached sheet for your Reference. Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Multiple filters in one spreadsheet area
Try Create table press ctrl + L On Mon, Aug 1, 2011 at 9:56 AM, Guzal Yusupova 9uzal.yusup...@gmail.comwrote: Is there any way to set up more than one filter in one sheet? Thank you!! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Remove HyperLink without Macro
1 only define for format text you can put any numerical value On Mon, Aug 1, 2011 at 7:51 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, =TEXT(C3;1) - Here whats 1 stands for please let me know. Thanks On Mon, Aug 1, 2011 at 2:40 PM, XLS S xlst...@gmail.com wrote: Hey, In any blank cell enter any value like 1,2,3,name..then copy the cell...and hold ctrl buttonthen.select hyperlink (with hold ctrl button) cellsnow..just right click.paste special select Multiply (in operation) then enter. On Mon, Aug 1, 2011 at 3:33 PM, Neelakanta AB neelakanta...@gmail.comwrote: Hi Not able to work on the same format suggested. Share little more details for this it will be very helpful. Thanks! On Mon, Aug 1, 2011 at 3:27 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, I tried but I could not able to get this. I am stuck up with point 2 i.e. Select the cell and press *Ctrl+C*. Please can u explain briefly regarding this. Thanks! On Sun, Jul 31, 2011 at 2:37 PM, GoldenLance samde...@gmail.comwrote: Nice one XLS S On Jul 31, 10:41 am, XLS S xlst...@gmail.com wrote: Dear All, Try this 1. In a blank cell, enter the number 1. 2. Select the cell and press *Ctrl+C*. 3. Hold down the *Ctrl* key as you click each hyperlink you want to remove. 4. Right Click and Choose Paste Special from 5. Select the Multiply radio button (In Operations). 6. Click OK. All the hyperlinks are removed, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips
Re: $$Excel-Macros$$ journal entry
see if it helps On Mon, Aug 1, 2011 at 5:43 PM, Ananta Sapkota sapkota.ana...@gmail.comwrote: I want to enter journal voucher from one sheet of excel. And data of relevant account type must be entry its exact sheet. On Mon, Aug 1, 2011 at 11:56 AM, ashish koul koul.ash...@gmail.comwrote: can you explain it in detail On Sun, Jul 31, 2011 at 11:34 AM, Ananta Sapkota sapkota.ana...@gmail.com wrote: I have attached file which gives us simple idea whatever i want to do. Please help me. It's urgent for me to keep accounting record. ananta Sapkota -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel journal entry (1).xlsm Description: Binary data
RE: $$Excel-Macros$$ Dynamic Chart
Hi, See attached workbook Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Chandra Shekar Envoyé : lundi 1 août 2011 12:02 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Dynamic Chart Hi, I needed data for 12 weeks. In attached file I need chart for 30th - 41st week. If I enter 42nd week data I need chart from 31st - 42nd Week chart. Thanks in advance. On Fri, Jul 29, 2011 at 5:47 PM, Rajan_Verma rajanverma1...@gmail.com wrote: See the attached Workbook From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, July 29, 2011 7:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic Chart Hi, Can u pls help me in doing dynamic chart in attached file. I tried using formulas which is in attacthed file. But I could not able to do the same. I need only 12 weeks data in the chart. Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Book1 (5).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Entered data should be locked
HI, Sometimes, you have no choice. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de muralidhar e Envoyé : lundi 1 août 2011 13:32 À : excel-macros@googlegroups.com Objet : Fwd: $$Excel-Macros$$ Entered data should be locked Hello friend, Thank you but i need without macros is it possible to do this it is more helpful to me. Regards, Muralidhar E. -- Forwarded message -- From: Daniel dcolarde...@free.fr Date: Sun, Jul 31, 2011 at 8:44 PM Subject: RE: $$Excel-Macros$$ Entered data should be locked To: excel-macros@googlegroups.com Hello, I protected the sheet (password : excel). In the sheet module I put the macro : Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range ActiveSheet.Unprotect excel For Each c In Target If c Then c.Locked = True Next c ActiveSheet.Protect excel End Sub Have a look at the attached workbook. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de muralidhar e Envoyé : dimanche 31 juillet 2011 14:25 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Entered data should be locked Dear Friends, If any one can helped can be appreciated i have data like frequently repeated data so i would like to lock the entered data and it should not be modified i.e. my file should allow empty cells should be entered, if any correction or modification needed that should ask the password.If the help is without macro is better to me. -- Thanks Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help in Training room booking system
Hi, I want to create a Training room(or Auditorium etc.) booking system. How should I create it? What features should I add? If anyone have this kind of template then please send me. Waiting for your response. Thanks Regards, Alisha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Entered data should be locked
Hi Muralidhar Try : 1.First select all cells (Ctrl + A) on worksheet 2.Right Click Go to Format cells 3.Select Protection Tab 4.uncheck Locked 5.Right Click on sheet tab select view code 6.Paste below code Private Sub Worksheet_Change(ByVal Target As Range) Const pw As String = password With Me .Unprotect pw Target.Locked = True .Protect pw End With End Sub Thanks Mahesh On Mon, Aug 1, 2011 at 9:53 PM, Daniel dcolarde...@free.fr wrote: HI, ** ** Sometimes, you have no choice. ** ** Regards. ** ** Daniel ** ** *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* muralidhar e *Envoyé :* lundi 1 août 2011 13:32 *À :* excel-macros@googlegroups.com *Objet :* Fwd: $$Excel-Macros$$ Entered data should be locked ** ** Hello friend, Thank you but i need without macros is it possible to do this it is more helpful to me. Regards, Muralidhar E. -- Forwarded message -- From: *Daniel* dcolarde...@free.fr Date: Sun, Jul 31, 2011 at 8:44 PM Subject: RE: $$Excel-Macros$$ Entered data should be locked To: excel-macros@googlegroups.com Hello, I protected the sheet (password : excel). In the sheet module I put the macro : Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range ActiveSheet.Unprotect excel For Each c In Target If c Then c.Locked = True Next c ActiveSheet.Protect excel End Sub Have a look at the attached workbook. Regards. Daniel *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* muralidhar e *Envoyé :* dimanche 31 juillet 2011 14:25 *À :* excel-macros@googlegroups.com *Objet :* $$Excel-Macros$$ Entered data should be locked Dear Friends, If any one can helped can be appreciated i have data like frequently repeated data so i would like to lock the entered data and it should not be modified i.e. my file should allow empty cells should be entered, if any correction or modification needed that should ask the password.If the help is without macro is better to me. -- *Thanks Regards,* *Muralidhar E.* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Thanks Regards,* *Muralidhar E.* ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel --
$$Excel-Macros$$ remove duplicates - is it a good code?
Hi all Experts, Below is the code I produced following my learning of vba for Excel from excelvbasql.com. I would like to know if there is anything to be done about this code. I'm looking to learn from anyone who can share his/her experience. Cheers, Option Explicit Sub DeleteDupl2() Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Dim wb As Workbook Dim ws As Worksheet Set wb = ThisWorkbook Set ws = wb.Worksheets(sheet1) Dim lastr As Long, lastc As Long Dim i As Integer, j As Integer Dim icopy As Integer Dim Table() As Variant 'Array for all values Dim TableOK() As Variant 'Array for unique values Dim iOkSize As Integer, jOkSize As Integer 'Rows and column size for TableOK Dim iOK As Integer, jOk As Integer Dim idD As String 'to concatenate all values in a rows Dim idj As Integer 'loop variable to concatenate idD string Dim deleteSt As String deleteSt = ---%%% lastr = ws.Cells(Rows.Count, 1).End(xlUp).Row lastc = ws.Range(A1).End(xlToRight).Column ReDim Table(lastr - 2, lastc) ReDim TableOK(0, 0) '''Copy data into Array Table '''Concatenate column values into an addito For i = 2 To lastr For j = 0 To lastc - 1 Table(i - 2, j) = ws.Cells(i, j + 1) Next j For idj = 1 To lastc idD = CStr(idD) CStr(ws.Cells(i, idj)) Next idj Table(i - 2, j) = CStr(idD) idD = Next i '''mark duplicates but keep untouched the original value For i = 0 To lastr - 2 j = lastc idD = Table(i, j) For j = i + 1 To lastr - 2 If CStr(Table(j, lastc)) = CStr(idD) And Right(CStr(Table(j, lastc)), 6) ---%%% Then Table(j, lastc) = CStr(Table(j, lastc)) ---%%% End If Next j Next i Range(ws.Cells(2, 1), ws.Cells(lastr, lastc)).ClearContents '''Count unique values in Table For i = 0 To lastr - 2 If CStr(Right(Table(i, lastc), 6)) deleteSt Then iOkSize = iOkSize + 1 End If Next i iOkSize = iOkSize - 1 jOkSize = lastc ReDim TableOK(iOkSize, jOkSize) ''Copy unique values into TableOK For i = 0 To lastr - 2 If CStr(Right(Table(i, lastc), 6)) deleteSt Then For j = 0 To lastc TableOK(iOK, jOk) = Table(i, j) jOk = jOk + 1 Next j iOK = iOK + 1 jOk = 0 End If Next i ''Copy unique values in worksheet For i = 0 To iOkSize For j = 0 To jOkSize - 1 ws.Cells(i + 2, j + 1) = TableOK(i, j) Next j Next i Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * *~~ With Best Regards ~~ * *~(Sourav.Kamra)~ * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled 1 to X to Word.
can you attach any workbook and word document how you will like the output to be On Tue, Aug 2, 2011 at 12:06 AM, skyping1 kevinrobertg...@hotmail.comwrote: I have many Excel files in a folder which all have labelled Worksheets from 1 to X where X is always an integer. Most of the files have about 10 worksheets, and these can have both text and pictures in. I have searched, for some code (to no avail and through quite a few forums!!), that would copy the content of the worksheets in numeric order to a blank Word document. I am using 2010, and ideally would like to select any number of files and even perhaps the order(!) that they can be pasted into Word. Hope you guys can help. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification
Sam Are you asking me or to whom you are referring to call you? Here is my number : 09866902757 On Tue, Aug 2, 2011 at 5:25 AM, Sam K soura...@gmail.com wrote: give me call at 12 tomorrow; or leave sms 028482 On Mon, Jul 25, 2011 at 7:00 PM, krishna mummina lovemekris...@gmail.comwrote: Hi Group, My Name is krishna, Working as a Data Analyst from the last 3 years. My daily work includes working with excel, Creating General Reports, Pdf to Excel Conversion, Data Mining and Analyzing data by using Data Tools like, Filter, Formulas, Sorting etc.. But I got a mail from one of my friend, It is an Opening for MIS Executive. I just want to know the exact qualification needed for the job. I mean, what are the Tools i need to know, I know, Many of us are already well settled. So, I just want to know from you people, Thanking you and Waiting for your reply - Krrish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * *~~ With Best Regards ~~ * *~(Sourav.Kamra)~ * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Poem - जोर से बोलो दम लगा के जय, Excel -Macro परिवार.
Bohot hi umda shayri hai Noorain saahab. Keep going.. 2011/8/2 Dilip Pandey dilipan...@gmail.com Hey Noorain... you are good poet.. with wonderful vocabulary.. this is awsome.. Thanks, DILIPandey On 7/30/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Experts, I have written a poem on our group to complete 8000 Members in EXCEL-MACRO faimly. read and Enjoy... जहा रोज सैकड़ों Questions की होती है बौछार. फिर लगते है अति-उत्तम Answers की कतार. जहा Excel-Experts की है बहूत बड़ी भरमार. सदस्य संख्या जिसकी हो चुकी है 8 हज़ार. वो है यारों अपना Excel-Macro परिवार. होती है बरसात यहाँ Excel के फोर्मुलों की. स्वाद सभी लेते है Logic के रसगुल्लों की. Question चाहे हो टेढ़ा, चाहे हो आसान. यहाँ हर समस्या Excel की बनती है समाधान. Excel -Experts की Army जहा बैठी है तैयार. ताक़ में है कब आये कोई query रूपी शिकार. वो है यारों अपना Excel-Macro परिवार. धन्यवाद का Button जब करते है हम PUSH जी. सबसे पहले याद आते है अपने ग्रुप मैनेजर आयुष जी. Technique है जिनका सीधा-साधा,पर logic है बहूत deep जी. उस Excel -Expert का नाम है Pandey Mr dilip जी. जब चली है बात एक्सपर्ट की तो उन्हें भी देदे WISH . Group का दुलारा,सबके आँखों का तारा,Koul Mr आशीष. DAVE,PAUL,DANIEL,STD(V) इस ग्रुप के कोहिनूर है. MAHESH,HASEEB,VENKAT के different Logic सदा से मशहूर है. और जो एक्सपर्ट हर Query के answer खातिर रहते है बेकाबू. वो है अपने छैल-छबीले पुने वाले हंसमुख राजन बाबु. सुमधुर लगती है अगर इस ग्रुप की मुरली की तान. तो उसमे हर सदस्य का है यारों बहुमूल्य योगदान. ग्रुप के सारे सदस्यों की महिमा यु बनी रहे आपार. दुआ है दिन-दुनी रात चौगुनी हो इसका बिस्तार. जोर से बोलो दम लगा के जय Excel -Macro परिवार. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
