Re: $$Excel-Macros$$ Import XML

[rf1234 rf1234]

Hello Dear

Two ways you can import your XML Data in your Workbook


1. Manually Importing XML Data
2. Programmatically Importing XML Data

Now how to…….

1. Manually Importing XML Data:
1.  Start Excel and then click Open on the File menu.
2.  In the Files of type list, select XML files.
3.  Select the XML file you want to open and then click Open.
4.  If the file has multiple XSL style sheets, you are prompted to
select one of the style sheets. Select a style sheet if you want to
apply a style sheet. Or, click Cancel to not select a style sheet.

2. Programmatically Importing XML Data:
'  represents the Web server
' location and the name of the XML file you want to save. You can also
' specify a folder on your hard disk rather than a URL.
'
' If the XML file references more than one style sheet,
' use the StyleSheets parameter to specify one or more style
' sheets. If you want to apply only one referenced style sheet,
' specify the index number of that sheet reference in the document.
' If you want to apply multiple style sheets, enter all
' the index numbers as members of an array, similar to this:
'
' Array(1, 2)
'
' In this case, the first and second style sheets are referenced in
' the XML file.
'
Workbooks.OpenXML "", _

Re: $$Excel-Macros$$ Is there a method to find distinct values in a column

[rf1234 rf1234]

Hello Dear
1 of the easiest method is,

Select the range
Data-->Filter-->Advance Filter-->Unique Record Only





For more have the attached Excel Macro.







Hope it Will Help
Happy To Help
:)
Prashant Tripathi

On Fri, Apr 9, 2010 at 1:29 AM, Rajesh Nair  wrote:
> Hi All,
>
> Please help me to find a method to find distinct values in a column by
> clicking a command button
>
> Regards,
> Rajesh. Nair
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


SHOW_UNIQUE_VALUE_ONLY.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

[rf1234 rf1234]

Hello Dear
This is excel 2007 Compatibility issue,
Please contact or chat with Microsoft Specialist

https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1










Hope it Will Help
Happy To Help
:)
Prashant Tripathi

On Fri, Apr 9, 2010 at 5:21 AM, Vinod N  wrote:
> Hi Gurus,
> At my workplace, we use Excel 2007(Licensed). We maintain daily volume
> tracker(shared) and the same will be updated by my team members (8~10). They
> save the file systematically, one after another. As you are aware, if one
> user saves the shared file and at the same time another used saves the file,
> Excel will prompt Message such as "File is locked by User1" etc. So, after
> giving a  gap of 3-5 seconds the second user tries to save the file again.
> Excel 2007 automatically closes the current shared file and creates a temp
> file in place of the existing file. This is leading to a lot of time wasted
> in consolidation as we have piles of data. Further, if the user continues to
> work on the temp file without knowing that a temp file is created, the data
> saved by him is lost and thus is irretrievable.
> Earlier we were using Excel 2003 and we had no issues/problems.. but the day
> we started using 2007 we have started getting problems.
> We have taken the following step to curb the issue but the issue still
> exists:
>
> Re-created the Tracker in 2007 instead of just doing a Save As 2003 file to
> 2007 file to overcome Compatibility issues.
> Mapped the shared drive as a "Trusted Site" in Excel
> Re-installed Excel in all the systems...
>
> Please help me
> Thanks and Regards
> Vinod N
> http://cavinod.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 Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 47 Messages in 19 Topics

[rf1234 rf1234]

Hello Dear,

Try to use
tools-->macro-->vbaeditor-->insertmodule

and try to run simple programe

http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm











Hope it Will Help
Happy To Help
:)
Prashant Tripathi

On Fri, Apr 9, 2010 at 9:46 AM, nikhil deshpande  wrote:
>
> Kindly guide me to work in macros, how it works and how to use it.
> Nikhil.
> On Fri, Apr 9, 2010 at 4:58 AM, 
> wrote:
>>
>>   Today's Topic Summary
>>
>> Group: http://groups.google.com/group/excel-macros/topics
>>
>> Allow row hiding /unhiding with password protection [2 Updates]
>> time management VBA code for txt file [2 Updates]
>> Upload Excel data to Access, but Access not installed [5 Updates]
>> Need Passward Cracker [1 Update]
>> Urgent Help [3 Updates]
>> Need urgent help. [7 Updates]
>> Plz Help me urgent [5 Updates]
>> IMPORT FIXED WIDTH TXT FILE TO EXCEL [3 Updates]
>> Selecting cutting combinations of fabric [1 Update]
>> Count number of times a part is out of stock without counting all days
>> part is out of stock [1 Update]
>> Need Help to find a date and time calculation [1 Update]
>> how can protect the excel sheet in VBA Passward. [1 Update]
>> Does anybody have games [2 Updates]
>> Excel, go through Column B [1 Update]
>> How to use logical expression in find method? [3 Updates]
>> : HELP [1 Update]
>> HELP: Appending multiple sheet into one [3 Updates]
>> Single Data Type Number Length Growing [4 Updates]
>> Access 2007 Bible [1 Update]
>>
>>  Topic: Allow row hiding /unhiding with password protection
>>
>> Hanum  Apr 08 07:57AM -0700 ^
>>
>> I have an Excel report. The sheet needs to be password protected, at
>> the same time users should be able to hide/ unhide rows and columns.
>>
>> Is there a way to do it?
>> more...
>>
>> Paul Schreiner  Apr 08 10:41AM -0700 ^
>>
>> Hide/Unhide is considered "formatting" of rows/columns
>> When you protect the sheet, select the
>> Format Rows
>> Format Columns
>>
>> checkboxes.
>>
>>
>>
>>
>>  more...
>>
>>  Topic: time management VBA code for txt file
>>
>> OSAVentures Calamba  Apr 08 05:58PM +0800 ^
>>
>> *Dear VBA Experts,*
>>
>> I'm wondering if there is a code possible to summarize the contents of a
>> text file as partly shown below.
>> I received this file at a certain period. Thousands rows of records.
>> more...
>>
>> paulwillekens  Apr 08 10:11AM -0700 ^
>>
>> Hi Grace,
>>
>> Let's start with this... If any changes are needed, just tell me...
>>
>> Kind regards,
>>
>> Paul Willekens
>> '===
>> more...
>>
>>  Topic: Upload Excel data to Access, but Access not installed
>>
>> Chechu  Apr 07 06:24PM -0700 ^
>>
>> Hi, I need some help in an export from Excel to Access macro. I have
>> an Excel tool which will be used by many users. In this Excel, I have
>> a range, let's say in Sheet 1, A1:B20, that I need to more...
>>
>> rf1234 rf1234  Apr 08 10:20AM +0530 ^
>>
>> Hello Dear,
>> It is possible to import export using ADO Controls,I am bit Confuse,
>> How i can send excel data to access when access is not install.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope it Will Help more...
>>
>> paulwillekens  Apr 08 02:19AM -0700 ^
>>
>> Hi Chechu,
>>
>> Why not export that particular range in a .csv file, that would be
>> stored in a dedicated folder on the network, and imported by Access on
>> its own time...
>> You need the macro to export more...
>>
>> Chechu  Apr 08 06:38AM -0700 ^
>>
>> Hi Paul,
>>
>> I'm glad that you have an option to deal with this. Yes, I am fully
>> open to your suggestion, each user exports as .csv in a shared drive
>> and then I import in my Access database, in my more...
>>
>> paulwillekens  Apr 08 09:01AM -0700 ^
>>
>> There are two sides:
>> a) the user side: if a1:b20 is all the sheet contains, the user could
>> save his sheet as "user.csv" in a particular folder
>> but if the range to import in access is only part of more...
>>
>>  Topic: Need Passward Cracker
>>
>> Jai  Apr 08 06:14PM +0530 ^
>>
>> Dear All,
>>
>> Can you Give me VBA Passward Cracker,
>> --
>> Thanks For Mail.
>> more...
>>
>>  Topic: Urgent Help
>>
>> sudhir kumar  Apr 08 01:50PM +0530 ^
>>
>> Hi Madhu
>>
>> Please solve this attachment.
>>
>>
>>
>> --
>> Sudhir Verma
>> Asstt. Mngr. A/c's
>> 9211219649
>> more...
>>
>> Dilip Pandey  Apr 08 05:56PM +0530 ^
>>
>> Dear Sudhir,
>>
>> Attached file has been solved per your requirements.
>>
>> Get back to me in case of any queries.
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>> MBA-HR,B.Com(Hons),BCA more...
>>
>> Suryaprasad  Apr 08 06:22PM +0530 ^
>>
>> Hey Sudhir,
>>
>> No need of a Look upOnly thing u can do a formulae for Transpose is
>> required..please find the attachement.
>>
>> Surya
>>
>> more...
>>
>>  Topic: Need urgent help.
>>
>> rf1234 rf1234  Apr 08 11:41AM +0530 ^
>>
>> Hello Dear,
>> Hope u have got some call,if not i have approx 100 consultancy e mail id.
>> if necessary reply

Re: $$Excel-Macros$$ Need Passward Cracker

[rf1234 rf1234]

Hello Dear
Open this add ins and then your protected workbook.
Follow the instruction.













Hope it Will Help
Happy To Help
:)
Prashant Tripathi

On Fri, Apr 9, 2010 at 10:09 AM, Jai  wrote:
>
>
>>
>> Dear All,
>>
>> Can you Give me VBA Passward Cracker,
>> --
>> Thanks For Mail.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


password.xla
Description: Binary data

Re: $$Excel-Macros$$ Need urgent help.

[rf1234 rf1234]

Dear All,
Last Day i was contacted by a good consultant,i am not keen join his offer.
if any 1 interested,can use following contact and mail





Contact Person:

CHANDRA SEKHAR


CHAITRA SOFT
#103 l Suresh Harivillu Apartments l Road No.11 l West Maradpally l
Secunderabad 500 026
Tel: 040-40101549 l 040-40130539 l Mobile: 9390228365 l
chan...@chaitrasoft.com


Mail:

Hi,

Greetings!!!


We have an opening for VBA developer


Client: HSBC, Pune


Position: Contract


Duration: 3 months extendable


Skill set:


• RAD VBA – Strong VBA, Macro writing skills on excel, ability to
develop reports & dashboards, understanding of production support
&incident management process
• RAD VBA – Strong VBA, Macro writing skills on excel, ability to
develop reports & dashboards, prior exp on reporting tools especially
crystal reports will be preferred


Please forward your updated profile with the fallowing details


Total years of exp:


Current organisation:


Current CTC:


Expected CTC:


Notice period:


DOB:


Pan card number/ passport number:


Thanks & Regards


CHANDRA SEKHAR


CHAITRA SOFT
#103 l Suresh Harivillu Apartments l Road No.11 l West Maradpally l
Secunderabad 500 026
Tel: 040-40101549 l 040-40130539 l Mobile: 9390228365 l
chan...@chaitrasoft.com




On Thu, Apr 8, 2010 at 5:25 PM, saroj.32006  wrote:
> Thank you...If possible can u also help us on Finance domain
> side. Completed MBA-Finance and having 4 yrs of Exp. in the Financial
> Services & Microfinance.
>
> On Thu, Apr 8, 2010 at 3:38 PM, rf1234 rf1234  wrote:
>>
>> Hello Dear,
>> Here is the files without zipped.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope it Will Help
>> Happy To Help
>> :)
>> Shyam
>>
>> On Thu, Apr 8, 2010 at 1:47 PM, ashish koul  wrote:
>> > hello sham
>> >
>> > your zip file is not woring at my place can u please send it in some
>> > other
>> > format
>> >
>> > On Thu, Apr 8, 2010 at 1:35 PM, rf1234 rf1234 
>> > wrote:
>> >>
>> >> Hello Dear,
>> >> Carry on Hard Work,Group is here to Help Needy People...
>> >> But Only for Excel,Vba
>> >> :)
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Hope It Will Help
>> >> Happy To Help
>> >> :)
>> >> Shyam
>> >>
>> >> On Thu, Apr 8, 2010 at 12:23 PM, saroj.32006 
>> >> wrote:
>> >> > Thank you...Its really a life saving help for
>> >> > the
>> >> > needy people.
>> >> > Thank you once again.
>> >> >
>> >> >
>> >> > On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234 
>> >> > wrote:
>> >> >>
>> >> >> Hello Dear,
>> >> >> Go through,attached zipped.
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> Hope it Will Help
>> >> >> Happy To Help
>> >> >> :)
>> >> >> Shyam
>> >> >>
>> >> >>
>> >> >>
>> >> >> On Mon, Apr 5, 2010 at 4:32 PM, Baby Patel
>> >> >> 
>> >> >> wrote:
>> >> >> > Hi All,
>> >> >> >
>> >> >> >
>> >> >> > The way this network is responding and working is amazing.
>> >> >> >
>> >> >> > I have many  learnt new tips out of this network. .
>> >> >> >
>> >> >> > Also I want to express myself that I am looking for a change.
>> >> >> > Am a Quality Ananlyst. 70% of my work is on excle.
>> >> >> >
>> >> >> > Your help in this matter will be highly appreciated.
>> >> >> >
>> >> >> > I am based in Pune.
>> >> >> >
>> >> >> > My contact No is 9370125136.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Baby Patel
>> >> >> >
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > --
>> >> >> > Some important links for excel users:
>> >> >> > 1. Follow us on TWITTER for tips tricks and links :
>> >> >> > http://twitter.com/exceldailytip
>> >> >> > 2. Join our Facebook Group @
>> >> >> > http://www.facebook.com/group.php?gid=287779555678
>> >> >> > 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
>> >> >> >
>> >> >> > <><><><><><><><><><><><><><><><><><><><><><>
>> >> >> > HELP US GROW !!
>> >> >> >
>> >> >> > We reach over 6,800 subscribers worldwide and receive many nice
>> >> >> > notes
>> >> >> > about
>> >> >> > the learning and support from the group.Let friends and co-workers
>> >> >> > know
>> >> >> > they
>> >> >> > can subscribe to group at
>> >> >> > http://groups.google.com/group/excel-macros/subscribe
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >>
>> >> >> Thanks Regards
>> >> >> Shyam
>> >> >> Software Engineer
>> >> >>
>> >> >>
>> >> >>
>> >> >> ''
>> >> >> When one door of happiness closes, another 

Re: $$Excel-Macros$$ Need Passward Cracker

[Jai]

> Dear All,
>
> Can you Give me VBA Passward Cracker,
> --
> Thanks For Mail.
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

RE: $$Excel-Macros$$ MATCH question

[Dave Bonallack]

Hi Tom,

Since you only seem to have 2 ranges, you could just name them, then use the 
names in your formulas.

 

Regards - Dave
 
> Date: Thu, 8 Apr 2010 16:06:06 -0700
> Subject: $$Excel-Macros$$ MATCH question
> From: tomfabtas...@hotmail.com
> To: excel-macros@googlegroups.com
> 
> Hi,
> 
> In an excel worksheet, I have the below formulas in three different
> cells. Is there a way to replace the SR_P1!$1:$1, SR_P2!$1:$1, SR_P3!
> $1:$1 parts of the function by referencing another cell (maybe using
> the address function, or similar) ?
> 
> MATCH($A15&D$47, SR_P1!$1:$1, 0)
> MATCH($A15&D$47, SR_P2!$1:$1, 0)
> MATCH($A15&D$47, SR_P3!$1:$1, 0)
> 
> I have tried typing "SR_P1!$1:$1" into cell A1 but the formula
> MATCH($A15&D$47, A1, 0) doesn't work.
> 
> Any suggestions ?
> 
> Regards,
> Tom
> 
> -- 
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 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
> 
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
> 
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
> 
> To unsubscribe, reply using "remove me" as the subject.
  
_
New, Used, Demo, Dealer or Private? Find it at CarPoint.com.au
http://clk.atdmt.com/NMN/go/206222968/direct/01/

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Upload Excel data to Access, but Access not installed

[Chechu]

Paul,

Thanks again, I really appreciate your help. I will send another post
with an Excel file to use as an example. Since the DB is not developed
yet, and I am finishing the Excel tool, we are in the perfect world;
we can decide how to handle.

You will see in the Excel a main sheet called Tracking. This one will
be filled by the user (~500 users) on a monthly basis. Critical: Start
month is variable, depends on the user settings. Basically from this
sheet I am trying to get in a database the output 1 and output 2 data.
I made this split, but can be modified since again, I still need to
develop de DB.

I don't know if CSVs will work, since I have two different types of
output: One financial, another one hours by resource. Format/data
required are slightly different. If I have to start without your help,
I would try to create Output 1 and Output 2 (so I don't need to
increase the file size by having this tabs there), Export these tabs
to a separate file, save this new file to the shared drive with name =
Engagement ID, overwrite if exists (since each month each user will
submit a new version).

On a monthly basis, I should update the Access DB, or... allow each
"power user" to loop through the saved files and update their own db.
With Power User I mean a small group of people, which are going to be
the users of the consolidated DB.

Well, this looks to complex for me... As I said, I really appreciate
your help and guidance... I will send right now a separate e-mail
(same subject) with the Excel file. May be it looks too complex for me
but it is easier than what I see

THANKS!
Chechu



On Apr 8, 1:01 pm, paulwillekens 
wrote:
> There are two sides:
> a) the user side: if a1:b20 is all the sheet contains, the user could
> save his sheet as "user.csv" in a particular folder
> but if the range to import in access is only part of the sheet, maybe
> I could develop a little macro to export only that part... You tell
> me !
> b) the central access file: I need the layout to write to, but just as
> an example I will write here a .vbs to write that .csv to your .mdb...
> by the way, my .vbs could grab the data from without the regular .xls
> too, but then the initiative is no longer in the user hand, but
> centralized... You tell me!
>
> till then
>
> Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Allow row hiding /unhiding with password protection

[Hanum]

Thanks Paul, it works perfect.


On Apr 8, 10:41 am, Paul Schreiner  wrote:
> Hide/Unhide is considered "formatting" of rows/columns
> When you protect the sheet, select the
> Format Rows
> Format Columns
>
> checkboxes.
>
> 
> From: Hanum 
> To: MS EXCEL AND VBA MACROS 
> Sent: Thu, April 8, 2010 10:57:08 AM
> Subject: $$Excel-Macros$$ Allow row hiding /unhiding with password protection
>
> I have an Excel report.  The sheet needs to be password protected, at
> the same time users should be able to hide/ unhide rows and columns.
>
> Is there a way to do it?
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

[Vinod N]

Hi Gurus,

At my workplace, we use Excel 2007(Licensed). We maintain daily volume
tracker(shared) and the same will be updated by my team members (8~10). They
save the file systematically, one after another. As you are aware, if one
user saves the shared file and at the same time another used saves the file,
Excel will prompt Message such as "File is locked by User1" etc. So, after
giving a  gap of 3-5 seconds the second user tries to save the file again.

Excel 2007 automatically closes the current shared file and creates a temp
file in place of the existing file. This is leading to a lot of time wasted
in consolidation as we have piles of data. Further, if the user continues to
work on the temp file without knowing that a temp file is created, the data
saved by him is lost and thus is irretrievable.

Earlier we were using Excel 2003 and we had no issues/problems.. but the day
we started using 2007 we have started getting problems.

We have taken the following step to curb the issue but the issue still
exists:

   1. Re-created the Tracker in 2007 instead of just doing a Save As 2003
   file to 2007 file to overcome Compatibility issues.
   2. Mapped the shared drive as a "Trusted Site" in Excel
   3. Re-installed Excel in all the systems...

Please help me

Thanks and Regards

Vinod N
http://cavinod.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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ MATCH question

[tomfabtas...@hotmail.com]

Hi,

In an excel worksheet, I have the below formulas in three different
cells. Is there a way to replace the SR_P1!$1:$1, SR_P2!$1:$1, SR_P3!
$1:$1 parts of the function by referencing another cell (maybe using
the address function, or similar) ?

MATCH($A15&D$47, SR_P1!$1:$1, 0)
MATCH($A15&D$47, SR_P2!$1:$1, 0)
MATCH($A15&D$47, SR_P3!$1:$1, 0)

I have tried typing "SR_P1!$1:$1" into cell A1 but the formula
MATCH($A15&D$47, A1, 0) doesn't work.

Any suggestions ?

Regards,
Tom

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Is there a method to find distinct values in a column

[Rajesh Nair]

Hi All,

Please help me to find a method to find distinct values in a column by
clicking a command button

Regards,
Rajesh. Nair

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


distinct.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Import XML

[OldDog]

Hi,

I recorded a macro in Excell 2007 to import an xml file.
As I wnet through the steps manualy everything workeed fine.

When i try to run the macro I get an error.

Here is the macro I recorded:

Sub xml2()
'
' xml2 Macro
'

'
Range("A1").Select
ActiveWorkbook.XmlMaps("SecScan_Map").Import URL:= _
"C:\Documents and Settings\My Documents\Scripts\xml
\MSGWBESIADSM10.xml"

End Sub

And here is the error:

Rub-time error '9':

Subscript out of range.

What do I need to do to fix this?

TIA;

OldDog

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Allow row hiding /unhiding with password protection

[Paul Schreiner]

Hide/Unhide is considered "formatting" of rows/columns
When you protect the sheet, select the 
Format Rows
Format Columns

checkboxes.





From: Hanum 
To: MS EXCEL AND VBA MACROS 
Sent: Thu, April 8, 2010 10:57:08 AM
Subject: $$Excel-Macros$$ Allow row hiding /unhiding with password protection

I have an Excel report.  The sheet needs to be password protected, at
the same time users should be able to hide/ unhide rows and columns.

Is there a way to do it?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: time management VBA code for txt file

[paulwillekens]

Hi Grace,

Let's start with this... If any changes are needed, just tell me...

Kind regards,

Paul Willekens
'===
Sub CalcTime()

Dim cCode
Dim cDatum
Dim cOldCode
Dim cTime

Dim dDate

Dim lIn

Dim nTime
Dim nPosInOut
Dim nPosSpace
Dim nRowIn
Dim nRowOut

cOldCode = ""
lIn = False
nRowIn = 1
nRowOut = 1
Cells(nRowOut, 3).Value = "Code"
Cells(nRowOut, 4).Value = "Date"
Cells(nRowOut, 5).Value = "Time in minutes"
nRowOut = nRowOut + 1

cContent = Cells(nRowIn, 1).Value
While Len(cContent) > 0
  nPosSpace = InStr(cContent, " ")
  cCode = Left(cContent, (nPosSpace - 1))
  cDatum = Mid(cContent, (nPosSpace + 1), 8)
  cTime = Mid(cContent, (nPosSpace + 9), 4)
  nPosInOut = InStr(nPosSpace, cContent, "A")

  If nPosInOut > 0 Then 'A = log IN
If lIn Then
  'skip this line
Else
  lIn = True
  dDate = DateSerial(Left(cDatum, 4), Mid(cDatum, 5, 2),
Right(cDatum, 2))
  cOldCode = cCode
  nTime = Left(cTime, 2) * 60 + Right(cTime, 2)
End If
  Else 'Z = log OUT
If lIn Then
  lIn = False
  If cCode = cOldCode Then
cOldCode = ""
nTime = (Left(cTime, 2) * 60 + Right(cTime, 2)) - nTime
Cells(nRowOut, 3).Value = cCode
Cells(nRowOut, 4).Value = dDate
Cells(nRowOut, 5).Value = nTime
nRowOut = nRowOut + 1
  End If
Else
  'skip this line
End If
  End If
  nRowIn = nRowIn + 1
  cContent = Cells(nRowIn, 1).Value
Wend

MsgBox "Done at row " & (nRowIn - 1)

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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Upload Excel data to Access, but Access not installed

[paulwillekens]

There are two sides:
a) the user side: if a1:b20 is all the sheet contains, the user could
save his sheet as "user.csv" in a particular folder
but if the range to import in access is only part of the sheet, maybe
I could develop a little macro to export only that part... You tell
me !
b) the central access file: I need the layout to write to, but just as
an example I will write here a .vbs to write that .csv to your .mdb...
by the way, my .vbs could grab the data from without the regular .xls
too, but then the initiative is no longer in the user hand, but
centralized... You tell me!

till then

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Allow row hiding /unhiding with password protection

[Hanum]

I have an Excel report.  The sheet needs to be password protected, at
the same time users should be able to hide/ unhide rows and columns.

Is there a way to do it?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Upload Excel data to Access, but Access not installed

[Chechu]

Hi Paul,

I'm glad that you have an option to deal with this. Yes, I am fully
open to your suggestion, each user exports as .csv in a shared drive
and then I import in my Access database, in my computer.
I will really appreciate your help/guidance on this. I don't know
where to start, I never worked with this kind of export/import out of
Excel
THANKS a lot,
Chechu


On Apr 8, 6:19 am, paulwillekens 
wrote:
> Hi Chechu,
>
> Why not export that particular range in a .csv file, that would be
> stored in a dedicated folder on the network, and imported by Access on
> its own time...
> You need the macro to export the range in Excel, and a macro in Access
> to check for those files and import them...
> If that idea suits you, tell me and I'll see to it.
>
> Greetings,
>
> Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Urgent Help

[Suryaprasad]

Hey Sudhir,

No need of a Look upOnly thing u can do a formulae for Transpose is
required..please find the attachement.

Surya

On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar  wrote:

> *Hi friends*
> **
> *Please help me urgent*
> *problem of Hlookup formula in attached file.
> *
> --
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9211219649
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Help.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Need Passward Cracker

[Jai]

Dear All,

Can you Give me VBA Passward Cracker,
-- 
Thanks For Mail.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Need urgent help.

[saroj.32006]

Thank you...If possible can u also help us on Finance domain
side. Completed MBA-Finance and having 4 yrs of Exp. in the Financial
Services & Microfinance.


On Thu, Apr 8, 2010 at 3:38 PM, rf1234 rf1234  wrote:

> Hello Dear,
> Here is the files without zipped.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
> On Thu, Apr 8, 2010 at 1:47 PM, ashish koul  wrote:
> > hello sham
> >
> > your zip file is not woring at my place can u please send it in some
> other
> > format
> >
> > On Thu, Apr 8, 2010 at 1:35 PM, rf1234 rf1234 
> wrote:
> >>
> >> Hello Dear,
> >> Carry on Hard Work,Group is here to Help Needy People...
> >> But Only for Excel,Vba
> >> :)
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Hope It Will Help
> >> Happy To Help
> >> :)
> >> Shyam
> >>
> >> On Thu, Apr 8, 2010 at 12:23 PM, saroj.32006 
> >> wrote:
> >> > Thank you...Its really a life saving help for
> >> > the
> >> > needy people.
> >> > Thank you once again.
> >> >
> >> >
> >> > On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234 
> >> > wrote:
> >> >>
> >> >> Hello Dear,
> >> >> Go through,attached zipped.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Hope it Will Help
> >> >> Happy To Help
> >> >> :)
> >> >> Shyam
> >> >>
> >> >>
> >> >>
> >> >> On Mon, Apr 5, 2010 at 4:32 PM, Baby Patel <
> smritipatel2...@gmail.com>
> >> >> wrote:
> >> >> > Hi All,
> >> >> >
> >> >> >
> >> >> > The way this network is responding and working is amazing.
> >> >> >
> >> >> > I have many  learnt new tips out of this network. .
> >> >> >
> >> >> > Also I want to express myself that I am looking for a change.
> >> >> > Am a Quality Ananlyst. 70% of my work is on excle.
> >> >> >
> >> >> > Your help in this matter will be highly appreciated.
> >> >> >
> >> >> > I am based in Pune.
> >> >> >
> >> >> > My contact No is 9370125136.
> >> >> >
> >> >> > Thanks,
> >> >> > Baby Patel
> >> >> >
> >> >> >
> >> >> > --
> >> >> >
> >> >> >
> >> >> >
> --
> >> >> > Some important links for excel users:
> >> >> > 1. Follow us on TWITTER for tips tricks and links :
> >> >> > http://twitter.com/exceldailytip
> >> >> > 2. Join our Facebook Group @
> >> >> > http://www.facebook.com/group.php?gid=287779555678
> >> >> > 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
> >> >> >
> >> >> > <><><><><><><><><><><><><><><><><><><><><><>
> >> >> > HELP US GROW !!
> >> >> >
> >> >> > We reach over 6,800 subscribers worldwide and receive many nice
> notes
> >> >> > about
> >> >> > the learning and support from the group.Let friends and co-workers
> >> >> > know
> >> >> > they
> >> >> > can subscribe to group at
> >> >> > http://groups.google.com/group/excel-macros/subscribe
> >> >> >
> >> >>
> >> >>
> >> >>
> >> >> --
> >> >>
> >> >> Thanks Regards
> >> >> Shyam
> >> >> Software Engineer
> >> >>
> >> >>
> >> >>
> ''
> >> >> When one door of happiness closes, another opens;
> >> >>  but often we look so long at the closed door that we do not see the
> >> >>  one which has been opened for us.
> >> >> - Helen Keller
> >> >>
> >> >>
> >> >>
> ''
> >> >> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> >> >> aber oft schauen wir so lange auf die geschlossene Tür,
> >> >>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> >> >>
> >> >>
> >> >>
> ''
> >> >>
> >> >> --
> >> >>
> >> >>
> >> >>
> --
> >> >> Some important links for excel users:
> >> >> 1. Follow us on TWITTER for tips tricks and links :
> >> >> http://twitter.com/exceldailytip
> >> >> 2. Join our Facebook Group @
> >> >> http://www.facebook.com/group.php?gid=287779555678
> >> >> 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
> >> >>
> >> >> <><><><><><><><><>

Re: $$Excel-Macros$$ Urgent Help

[Dilip Pandey]

Dear Sudhir,

Attached file has been solved per your requirements.

Get back to me in case of any queries.

-- 
Thanks & Regards,

DILIP KUMAR PANDEY
 MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar  wrote:

> *Hi friends*
> **
> *Please help me urgent*
> *problem of Hlookup formula in attached file.
> *
> --
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9211219649
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Help by DiLipandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Plz Help me urgent

[Dilip Pandey]

Dear Vikas,

Try following options:-
1)  Copy the formula and move the desired cell, press Enter
2)  Select the formula and select the desired cell while pressing  shift key
(select the desired cell with the formula cell selected ) and press Ctrl + D
(to fill down the formula) OR press Ctrl + R (to fill formual towards right)

Let me know if you face any challenges

-- 
Thanks & Regards,

DILIP KUMAR PANDEY
 MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Thu, Apr 8, 2010 at 2:48 PM, Vikas Chouhan  wrote:

> hi,,
>
> dear i have one problem. how to copy and paste formula because this
> is array formula  function..
>
>
> On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey  wrote:
>
>> Hi Anil,
>>
>> Attached file is solved as per your requirements.  Formula is also there.
>> Let me know if you have any queries.
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>>  MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>>
>> On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena 
>> wrote:
>>
>>> Hi Dilip
>>> plz do the needful it is urgent
>>>
>>> I want the same ans match with ID and Questions ?
>>>
>>> Plz Sir show the Formula also
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Anil Saxena
>>>
>>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Vikas Chauhan
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_ccess without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Plz Help me urgent

[Dilip Pandey]

You are always welcome..!!

-- 
Thanks & Regards,

DILIP KUMAR PANDEY
 MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Thu, Apr 8, 2010 at 4:26 PM, Anil Saxena wrote:

> thanks lot Dilip Ji
>
>
> On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey  wrote:
>
>>  Hi Anil,
>>
>> Attached file is solved as per your requirements.  Formula is also there.
>> Let me know if you have any queries.
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>>  MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>>
>>  On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena > > wrote:
>>
>>> Hi Dilip
>>> plz do the needful it is urgent
>>>
>>> I want the same ans match with ID and Questions ?
>>>
>>> Plz Sir show the Formula also
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Anil Saxena
>>>
>>>
>>
>>
>>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ time management VBA code for txt file

[OSAVentures Calamba]

*Dear VBA Experts,*

I'm wondering if there is a code possible to summarize the contents of a
text file as partly shown below.
I received this file at a certain period. Thousands rows of records. Each
data contains code and date  time stamps. The first line is logged in and
the next logged out, then next row logged in data again and so forth.

I wanted to extract data from a txt file, and summarized the total hours (
logged out-logged in) for all the days for each code.
I hope I explain it well.  Doing this manually in excel is a very tedious
process.

M09097461 =code
2010-03-23-0649- =time
A1= "data not important"


M09097461 201003230649A1 - > logged in
M09097461 201003232008Z006825001- > logged out
M09097461 201003240641A1->logged in
M09097461 201003242008Z007280001->logged out...
M09097461 201003250653A1
M09097461 201003252000Z004095001
M09097461 201003260645A1
M09097461 201003260645A1
M09097461 201003262011Z005460001
M09097461 201003262011Z005460001
M09097461 201003270645A1
M09097461 201003272015Z007735001
M09097461 201003280646A1
M09097461 201003282005Z007735001
M09097461 201003290657A1
M09097461 201003292007Z00911
M09097461 201003300701A1
M09097461 201003302015Z005005001
M09097461 201003310714A1
M09097461 201003311215Z014105001
M09067338 201003230716A1
M09067338 201003231740Z1
M09067338 201003240739A1
M09067338 201003241953Z1
M09067338 201003250659A1
M09067338 201003251938Z1
M09067338 201003260715A1
M09067338 201003261710Z1
M09067338 201003280715A1
M09067338 201003281715Z1
M09067338 201003290713A1
M09067338 201003291941Z1
M09067338 201003300715A1
M09067338 201003301943Z1
M09067338 201003310715A1
M09067338 201003311226Z015015001

thanks
Grace

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Re: IMPORT FIXED WIDTH TXT FILE TO EXCEL

[rf1234 rf1234]

Hello Dear,
Nice Article.Appriciate your team spirit.








On Thu, Apr 8, 2010 at 3:02 PM, paulwillekens
 wrote:
> Hi Vivek,
>
> No need to make a .csv
>
> Open the .txt and Excel will ask whether there is a separator or fixed
> length... Choose the latter and on the sample you move the vertical
> "separator" lines so to form the columns... then just import and
> adjust the column headings...
>
> Go for it !
>
> Greetings
>
> Paul Willekens
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Plz Help me urgent

[Abhishek Jain]

I guess you can drag it down/across. Or select the target area after copying
the formula and press Ctrl+V


On Thu, Apr 8, 2010 at 2:48 PM, Vikas Chouhan  wrote:

> hi,,
>
> dear i have one problem. how to copy and paste formula because this
> is array formula  function..
>
>
> On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey  wrote:
>
>> Hi Anil,
>>
>> Attached file is solved as per your requirements.  Formula is also there.
>> Let me know if you have any queries.
>>
>> --
>> Thanks & Regards,
>>
>> DILIP KUMAR PANDEY
>>  MBA-HR,B.Com(Hons),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 62, India
>>
>>
>> On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena 
>> wrote:
>>
>>> Hi Dilip
>>> plz do the needful it is urgent
>>>
>>> I want the same ans match with ID and Questions ?
>>>
>>> Plz Sir show the Formula also
>>>
>>>
>>>
>>>
>>> Regards
>>>
>>> Anil Saxena
>>>
>>>
>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Vikas Chauhan
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_ccess without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: IMPORT FIXED WIDTH TXT FILE TO EXCEL

[paulwillekens]

Hi Vivek,

No need to make a .csv

Open the .txt and Excel will ask whether there is a separator or fixed
length... Choose the latter and on the sample you move the vertical
"separator" lines so to form the columns... then just import and
adjust the column headings...

Go for it !

Greetings

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Upload Excel data to Access, but Access not installed

[paulwillekens]

Hi Chechu,

Why not export that particular range in a .csv file, that would be
stored in a dedicated folder on the network, and imported by Access on
its own time...
You need the macro to export the range in Excel, and a macro in Access
to check for those files and import them...
If that idea suits you, tell me and I'll see to it.

Greetings,

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Re: Plz Help me urgent

[Vikas Chouhan]

hi,,

dear i have one problem. how to copy and paste formula because this
is array formula  function..

On Thu, Apr 8, 2010 at 2:40 PM, Dilip Pandey  wrote:

> Hi Anil,
>
> Attached file is solved as per your requirements.  Formula is also there.
> Let me know if you have any queries.
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
>  MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena 
> wrote:
>
>> Hi Dilip
>> plz do the needful it is urgent
>>
>> I want the same ans match with ID and Questions ?
>>
>> Plz Sir show the Formula also
>>
>>
>>
>>
>> Regards
>>
>> Anil Saxena
>>
>>
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
One Team One Dream One Goal

Warm Regards,
Vikas Chauhan
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_ccess without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Selecting cutting combinations of fabric

[paulwillekens]

Hi Hugo,

Total width for the 4 first samples seems 3300mm to me, which is
greater than 3000mm... Or do I not understand your explanation well?

Please confirm and correct if necessary...

greetings

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Urgent Help

[sudhir kumar]

Hi Madhu

Please solve this attachment.


On 4/6/10, madhu nair  wrote:
>
>  Done, see attach
>
>
>
>
> On Tue, Apr 6, 2010 at 7:44 PM, sudhir kumar wrote:
>
>> *Hi friends*
>> **
>> *Please help me urgent*
>> *problem of Hlookup formula in attached file.
>> *
>> --
>> Sudhir Verma
>> Asstt. Mngr. A/c's
>> 9211219649
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> Thanks,
>
> Madhu Nair
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>


-- 
Sudhir Verma
Asstt. Mngr. A/c's
9211219649

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Help(1)(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Count number of times a part is out of stock without counting all days part is out of stock

[paulwillekens]

Here it comes...

Please feedback !

Kind regards,

Paul Willekens
'==
Sub BOcount()

Dim lBO

Dim nBO
Dim nCol
Dim nMax
Dim nRow

'first determine how many dates are registered
nCol = 2
While Len(Cells(1, nCol).Value) > 0
  nCol = nCol + 1
Wend
nMax = nCol - 1
Cells(1, nCol).Value = "new BO days"

'then check backorder days
nRow = 2
While Len(Cells(nRow, 1).Value) > 0
  nBO = 0
  lBO = False
  For nCol = 2 To nMax
If Cells(nRow, nCol).Value > 0 Then
  If Not lBO Then
lBO = True
nBO = nBO + 1
  End If
Else
  lBO = False
End If
  Next
  Cells(nRow, (nMax + 1)).Value = nBO

  nRow = nRow + 1
Wend

MsgBox "Done with row " & (nRow - 1)

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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Need urgent help.

[ashish koul]

hello sham

your zip file is not woring at my place can u please send it in some other
format

On Thu, Apr 8, 2010 at 1:35 PM, rf1234 rf1234  wrote:

> Hello Dear,
> Carry on Hard Work,Group is here to Help Needy People...
> But Only for Excel,Vba
> :)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hope It Will Help
> Happy To Help
> :)
> Shyam
>
>  On Thu, Apr 8, 2010 at 12:23 PM, saroj.32006 
> wrote:
> > Thank you...Its really a life saving help for the
> > needy people.
> > Thank you once again.
> >
> >
> > On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234 
> wrote:
> >>
> >> Hello Dear,
> >> Go through,attached zipped.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Hope it Will Help
> >> Happy To Help
> >> :)
> >> Shyam
> >>
> >>
> >>
> >> On Mon, Apr 5, 2010 at 4:32 PM, Baby Patel 
> >> wrote:
> >> > Hi All,
> >> >
> >> >
> >> > The way this network is responding and working is amazing.
> >> >
> >> > I have many  learnt new tips out of this network. .
> >> >
> >> > Also I want to express myself that I am looking for a change.
> >> > Am a Quality Ananlyst. 70% of my work is on excle.
> >> >
> >> > Your help in this matter will be highly appreciated.
> >> >
> >> > I am based in Pune.
> >> >
> >> > My contact No is 9370125136.
> >> >
> >> > Thanks,
> >> > Baby Patel
> >> >
> >> >
> >> > --
> >> >
> >> >
> --
> >> > Some important links for excel users:
> >> > 1. Follow us on TWITTER for tips tricks and links :
> >> > http://twitter.com/exceldailytip
> >> > 2. Join our Facebook Group @
> >> > http://www.facebook.com/group.php?gid=287779555678
> >> > 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
> >> >
> >> > <><><><><><><><><><><><><><><><><><><><><><>
> >> > HELP US GROW !!
> >> >
> >> > We reach over 6,800 subscribers worldwide and receive many nice notes
> >> > about
> >> > the learning and support from the group.Let friends and co-workers
> know
> >> > they
> >> > can subscribe to group at
> >> > http://groups.google.com/group/excel-macros/subscribe
> >> >
> >>
> >>
> >>
> >> --
> >>
> >> Thanks Regards
> >> Shyam
> >> Software Engineer
> >>
> >>
> ''
> >> When one door of happiness closes, another opens;
> >>  but often we look so long at the closed door that we do not see the
> >>  one which has been opened for us.
> >> - Helen Keller
> >>
> >>
> ''
> >> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> >> aber oft schauen wir so lange auf die geschlossene Tür,
> >>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> >>
> >>
> ''
> >>
> >> --
> >>
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our Facebook Group @
> >> http://www.facebook.com/group.php?gid=287779555678
> >> 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
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 6,800 subscribers worldwide and receive many nice notes
> >> about the learning and support from the group.Let friends and co-workers
> >> know they can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >>
> >> To unsubscribe, reply using "remove me" as the subject.
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> > http://www.facebook.com/group.php?gid=287779555678
> > 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-m

$$Excel-Macros$$ Re: Need Help to find a date and time calculation

[paulwillekens]

Here it comes...

greetings

Paul Willekens
'==
Sub Kleuren()

Dim nRow

nRow = 2

While Len(Cells(nRow, 1).Value) > 0
  If Cells(nRow, 5).Value >= Cells(nRow, 2).Value _
And Cells(nRow, 4).Value <= Cells(nRow, 3).Value Then
Range(Cells(nRow, 1), Cells(nRow, 5)).Interior.ColorIndex = 36
  Else
Range(Cells(nRow, 1), Cells(nRow, 5)).Interior.ColorIndex = 0
  End If
  nRow = nRow + 1
Wend

MsgBox "Done with row " & (nRow - 1)

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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Plz Help me urgent

[Dilip Pandey]

Hi Anil,

Attached file is solved as per your requirements.  Formula is also there.
Let me know if you have any queries.

-- 
Thanks & Regards,

DILIP KUMAR PANDEY
 MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India


On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena wrote:

> Hi Dilip
> plz do the needful it is urgent
>
> I want the same ans match with ID and Questions ?
>
> Plz Sir show the Formula also
>
>
>
>
> Regards
>
> Anil Saxena
>
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.


Questions-Solved by DiLipandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ how can protect the excel sheet in VBA Passward.

[rf1234 rf1234]

Hello Dear,

Following is the Code to Protect Unprotect Excel Sheet Using VBA.




''
Sub ProtectSheet()
Dim Password'This line of code is optional
Password = "1234aBcD"
ActiveSheet.Protect Password, True, True, True
End Sub
''
Sub UnProtectSheet()
Password = "1234aBcD"
ActiveSheet.Unprotect Password
End Sub

''








Hope it Will Help
Happy To Help
:)
Shyam

On Fri, Mar 26, 2010 at 5:40 PM, Jai  wrote:
> DEAR ALL,EXPERTS
>
> Can you Tell me that how can protect the excel sheet in VBA  Passward.
>
>
>
> --
> Thanks For Mail.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to
> excel-macros+unsubscribegooglegroups.com or reply to this email with the
> words "REMOVE ME" as the subject.
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Need urgent help.

[rf1234 rf1234]

Hello Dear,
Carry on Hard Work,Group is here to Help Needy People...
But Only for Excel,Vba
:)
















Hope It Will Help
Happy To Help
:)
Shyam

On Thu, Apr 8, 2010 at 12:23 PM, saroj.32006  wrote:
> Thank you...Its really a life saving help for the
> needy people.
> Thank you once again.
>
>
> On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234  wrote:
>>
>> Hello Dear,
>> Go through,attached zipped.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Hope it Will Help
>> Happy To Help
>> :)
>> Shyam
>>
>>
>>
>> On Mon, Apr 5, 2010 at 4:32 PM, Baby Patel 
>> wrote:
>> > Hi All,
>> >
>> >
>> > The way this network is responding and working is amazing.
>> >
>> > I have many  learnt new tips out of this network. .
>> >
>> > Also I want to express myself that I am looking for a change.
>> > Am a Quality Ananlyst. 70% of my work is on excle.
>> >
>> > Your help in this matter will be highly appreciated.
>> >
>> > I am based in Pune.
>> >
>> > My contact No is 9370125136.
>> >
>> > Thanks,
>> > Baby Patel
>> >
>> >
>> > --
>> >
>> > --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our Facebook Group @
>> > http://www.facebook.com/group.php?gid=287779555678
>> > 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
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 6,800 subscribers worldwide and receive many nice notes
>> > about
>> > the learning and support from the group.Let friends and co-workers know
>> > they
>> > can subscribe to group at
>> > http://groups.google.com/group/excel-macros/subscribe
>> >
>>
>>
>>
>> --
>>
>> Thanks Regards
>> Shyam
>> Software Engineer
>>
>> ''
>> When one door of happiness closes, another opens;
>>  but often we look so long at the closed door that we do not see the
>>  one which has been opened for us.
>> - Helen Keller
>>
>> ''
>> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
>> aber oft schauen wir so lange auf die geschlossene Tür,
>>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>>
>> ''
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe, reply using "remove me" as the subject.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer

Re: $$Excel-Macros$$ Need urgent help.

[saroj.32006]

Thank you...Its really a life saving help for the
needy people.

Thank you once again.



On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234  wrote:

> Hello Dear,
> Go through,attached zipped.
>
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
>
> On Mon, Apr 5, 2010 at 4:32 PM, Baby Patel 
> wrote:
> > Hi All,
> >
> >
> > The way this network is responding and working is amazing.
> >
> > I have many  learnt new tips out of this network. .
> >
> > Also I want to express myself that I am looking for a change.
> > Am a Quality Ananlyst. 70% of my work is on excle.
> >
> > Your help in this matter will be highly appreciated.
> >
> > I am based in Pune.
> >
> > My contact No is 9370125136.
> >
> > Thanks,
> > Baby Patel
> >
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> > http://www.facebook.com/group.php?gid=287779555678
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about
> > the learning and support from the group.Let friends and co-workers know
> they
> > can subscribe to group at
> > http://groups.google.com/group/excel-macros/subscribe
> >
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
>
> ''
> When one door of happiness closes, another opens;
>  but often we look so long at the closed door that we do not see the
>  one which has been opened for us.
> - Helen Keller
>
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>
> ''
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Excel, go through Column B

[paulwillekens]

Hi Shawn,

Question: are cells in column B always with content, up to the last
"used" row?

In that case... see below...

Kind regards,

Paul Willekens
'===
Sub GoColumnB()

Dim rngClnB As Range, Cell As Range

Sheets("OTHER").Activate

Set rngClnB = Intersect(Range("B:B"), ActiveSheet.UsedRange)

For Each Cell In rngClnB
  'Create Arguments here.
Next Cell

MsgBox "Done on row " & ActiveCell.Row()

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 Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.