$$Excel-Macros$$ Show Differences Between Buy & Sales in Pivot table

[B Sharma]

Dear Friends,
I have a database in which the transactions (both buy & sales) of shares 
trading has been entered.

I have another sheet in which I need results using Pivot table.

But it calculates the sum of both buy & sales, but I need the subtract of 
Buy with sales and show the balance results.

There is an option "Difference of" but it not showing proper results.

*I Can alternatively put minus signs in all the sales transactions but that 
is not possible for a big database.*

Any easy alternative solution will be highly appreciable.

Thanks in advance.
B. Sharma

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Buy & Sell of Shares.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

[B Sharma]

In addition to the above,,, 
You can check the path by the following formula

=Cell("filename")



On Wednesday, June 8, 2016 at 5:14:42 PM UTC+5:30, B Sharma wrote:
>
> Hiii Pravin,,
> From your screen shot I think that both the files are at different 
> location...
> Please check that in the first first there is only one sheet, and in the 
> another file there are 2 sheets (one new with name "Master")
>
> Please carefully check the path of the file which you open in the shared 
> computer, because I doubt that it could be the previously saved file / 
> older version of that file which you have saved..
>
> Please let us know about this ...
>
> Thanks & Regards,
> Bajrang sharma
>
>
> On Monday, May 30, 2016 at 4:55:18 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Dear Friend,
>>
>> Greetings!
>>
>> I have 3-4 computers in shared network. In one of them there is an excel 
>> file which contains data with 184 rows and 19 columns. If I open this file 
>> in the origin computer it shows data up to 184 rows but when I open the 
>> same file with other shared computer it shows only up to 173 rows.
>>
>> I have attached both the screen shorts for your immediate reference. 
>> Kindly help. Thanks,
>>
>> Regards,
>> Pravin Gunjal.
>>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: Excel is showing different data on other sharing computer

[B Sharma]

Hiii Pravin,,
>From your screen shot I think that both the files are at different 
location...
Please check that in the first first there is only one sheet, and in the 
another file there are 2 sheets (one new with name "Master")

Please carefully check the path of the file which you open in the shared 
computer, because I doubt that it could be the previously saved file / 
older version of that file which you have saved..

Please let us know about this ...

Thanks & Regards,
Bajrang sharma


On Monday, May 30, 2016 at 4:55:18 PM UTC+5:30, Pravin Gunjal wrote:
>
> Dear Friend,
>
> Greetings!
>
> I have 3-4 computers in shared network. In one of them there is an excel 
> file which contains data with 184 rows and 19 columns. If I open this file 
> in the origin computer it shows data up to 184 rows but when I open the 
> same file with other shared computer it shows only up to 173 rows.
>
> I have attached both the screen shorts for your immediate reference. 
> Kindly help. Thanks,
>
> Regards,
> Pravin Gunjal.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Cannot Use two namerange in one sumproduct(sumif( formula

[B Sharma]

Hello Excel Friends,
I am using the below formula which was working fine for me

=SUMPRODUCT(SUMIFS(range 1,criteria 1, range 2,Criteria 2,range 3,*Defined 
Name Range 1 *))

but I needed one more name range to add in this formula , but it stopped 
working and showing wrong results... 

Can somebody help me in this...
1. Cant I use two name range in a single formula
2. Which is the best way to get sumifs total with multiple criteria within 
a column (auto)

thanks in advance..

BS

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Pivot Table from multiple sheets

[B Sharma]

Dear André Luiz D´Avila,
Thanks for giving your valuable time for giving reply on my post. But what 
you replied is very simple and known to be but not useful as because: - 
1. The examplese (i.e. columns) in both purchase & sale sheet will be more 
than 50 per sheets. and that too different from each other. 
2. What you will do when you have 5000 nos. of purchases and more than 2 
000 invoices of sale. Then you will not keep one sheet for both the 
transactions.

I have prepared a very well planned excel program to monitor automatically 
all the finance / tax & accounts related work and my nos of sheets are very 
high. I want to minimize this by way of getting consolidated report through 
pivot.

Thanks once again.

BS

On Friday, March 13, 2015 at 7:59:51 PM UTC+5:30, André D'Avila wrote:
>
> Hello, 
> You have a excel sheet with table "purchase" and other one with "Sales".
>
> In order to combine both of them, the fast way is to create a 3 sheet.
>
> In that third one, create another table. Paste de "purchase table" and 
> below paste the Sales table.
>
> After that create a Pivot using this new table. I recommend to create a 
> macro to copy and paste each table constantly.
>
> I attached an exemple.
>
>
>
> André Luiz D´Avila
>
> 2015-03-13 10:41 GMT-03:00 B Sharma >:
>
>> Dear All Excel Experts,
>> From a very long time, I am trying to create a pivot table using two or 
>> more tables, but not getting appropriate results.
>>
>> Please help me , if anybody has ever done so.
>>
>> For e.g. in one table there are purchase details and in another column 
>> there are sale details..
>>
>> I want a combined pivot table which can show both the details at once 
>> with showing closing balances.
>>
>> A small database is attached for your reference.
>> I have searched a lot. The reference website is also not as per my needs 
>> as pivot table can be created but the result cannot be merged.
>> Thanks in advance.
>>
>>
>> BS
>> --
>>  Consolidate multiple worksheets into one PivotTable report 
>> <https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5>
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and 
>> members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com 
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Pivot Table from multiple sheets

[B Sharma]

Dear All Excel Experts,
>From a very long time, I am trying to create a pivot table using two or 
more tables, but not getting appropriate results.

Please help me , if anybody has ever done so.

For e.g. in one table there are purchase details and in another column 
there are sale details..

I want a combined pivot table which can show both the details at once with 
showing closing balances.

A small database is attached for your reference.
I have searched a lot. The reference website is also not as per my needs as 
pivot table can be created but the result cannot be merged.
Thanks in advance.


BS
--
 Consolidate multiple worksheets into one PivotTable report 


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Pivot Table from multiple tables.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Macro Required

[B Sharma]

Hii Vaibhav,

Happy to know that you are a CA too. That means you are a superman in 
accounting line. Because if a person is qualified CA and have good hands on 
excel/vba, that means he can do 8 hrs work in just 1 hr.

I am neither a CA nor a VBA expert but have good hands on excel, little bit 
of VBA & advance formulas and this helps me a lot in my day to day working. 
and minimized my work.

Anyways, you earlier vba helped me a lot.
Thanks man.

Thanks & Regards,
BS

On Friday, February 6, 2015 at 3:00:41 PM UTC+5:30, Vabz wrote:
>
> By profession i am in to CA too, n it is once personal interest n desire 
> to learn, since VBA is magical tool for everyone & if you expand your 
> knowledge it can be boon to CA office.
>
> Also believe me those not belonging to core VBA are also replying & 
> solving Queries at par with VBA experts.. 
>
> Yes i did had hands on it & I have trial ready with me, wanted to see your 
> work before posting...
>
> Appreciate your positive response!
>
> Cheers!!
>
>
> On Fri, Feb 6, 2015 at 2:51 PM, Kanwaljit Singh Dhunna  > wrote:
>
>> Hi Vaibhav, Thanks for the Concern !
>>
>> I understand everyone here is engaged in some profession but even then 
>> Some people like you spare time out of their busy schedule to help people 
>> out of trouble. I am a CA by profession and can do some good things in 
>> Excel but not in VBA. I tried learning VBA at some centres but none imparts 
>> VBA in the traditional sense of the learning. Also bought two books, one by 
>> John Walkenbach and other by Bill Jelen. Read some 150 pages of it. Gained 
>> some knowledge but yet I do not feel confident enough to deal with Web 
>> applications.
>>
>> Due to high stress of TDS returns now a days, I often come to 
>> Excel-Macros groups to find helps on issues I cannot deal with. These 
>> returns consuming a major portion of available time, even family time. So 
>> honestly even though I long to do experiments in VBA, I couldn't spare time 
>> yesterday to work on that. I understand that If I can't spend time on my 
>> issues then why anyone else should be interested in it. That's why I don't 
>> even requested again for anyone to solve it. I would certainly give it a 
>> shot, Not sure with present skills I can conclude it, but certainly there 
>> won't be any lack of efforts.
>>
>> Have you tried your hands on it ?
>>
>> On Fri, Feb 6, 2015 at 2:20 PM, Vaibhav Joshi 
>> > wrote:
>>
>>> Hi Kanwaljit
>>>
>>> Any luck?
>>>
>>> On Thu, Feb 5, 2015 at 5:06 PM, Vaibhav Joshi >> > wrote:
>>>
 yes, you an do it...



 On Thu, Feb 5, 2015 at 5:02 PM, Kanwaljit Singh Dhunna <
 kanw...@gmail.com > wrote:

> Ok Vaibhav. Even though I have very little idea about VB (Just read 
> the codes and try to understand them) I will give it a shot.
>
> On Thu, Feb 5, 2015 at 4:51 PM, Vaibhav Joshi  > wrote:
>
>> i want you to work on present requirement...
>>
>> On Thu, Feb 5, 2015 at 2:40 PM, Kanwaljit Singh Dhunna <
>> kanw...@gmail.com > wrote:
>>
>>> Ok Sir, I will do that.
>>>
>>> I hope I am clear on my present question.
>>>
>>> On Thu, Feb 5, 2015 at 2:28 PM, Vaibhav Joshi >> > wrote:
>>>
 You want to learn VBA then start modifying last code which i sent 
 to you to accommodate it..

 Start & letus know when you get error..

 Cheers!!


 On Thu, Feb 5, 2015 at 2:15 PM, Kanwaljit Singh Dhunna <
 kanw...@gmail.com > wrote:

> Hi Experts,
>
> I have attached a sheet.
> I wish there could be a macro which when run
> --assess the website given in column A1,
> --copy the value given in cell A4 in the input box
> --wait for me to enter the Captcha MANUALLY (as I have learnt that 
> it is quite a tedious process via code)
> --copy the resulting values and paste them into the required 
> columns in the sheet (if the input value is invalid then only Mark 
> INVALIDPAN in column B)
> --copy and value given in Next Cell i.e., A5 and so on till the 
> List is exhausted.
>
> Hope I am clear !
>
>
> -- 
> Sincere Regards
> CA Kanwaljit Singh Dhunna
> +91-987 6739 911
> +91-950 1031 007
> P*Please don't print this e-mail unless you really need to.*
> *IF U LOSE, DON'T LOSE THE LESSON.*
>  
> -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna 
> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this 
> forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like 
> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and 
> Need 
> Advice

$$Excel-Macros$$ Automatic update excel file from website

[B Sharma]

Dear Excel Gurus,
I am trying to update my excel sheet which contains the TIN number of some 
of the registered tax payers with their contact details and address. I can 
do it manually by putting the TIN number in the below mentioned website and 
then copy paste the details in the excel file.

But is there any way to do it automatically with the help of macros / VBA???

https://www.odishatreasury.gov.in/echallan/ChallanSubmission.do?deptcode=COM

In the above mentioned website if you put the TIN number (for 
e.g. 21031209766) then it will give the details and can I make it an 
automatically copy paste the data in my excel sheet???

Can it be possible with web query???

Please help ..

BS

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: conditional formating to find amts to offset

[B Sharma]

Dear Santosh,
Please find the file, Hope this will help you..

On Sunday, March 24, 2013 2:09:41 PM UTC+5:30, santosh wrote:
>
> Hello Group,
>
> I need a way to highlight the amts that I can offset with each other based 
> on the below conditions:
>
> 1) Customer should be same
> 2) Profit Center has to be same
>
> I need to do this *with out macros.*
> *
> *
> Any type of help would be of great help.
> -- 
> Regards
> Santosh 
> santoshkum...@gmail.com  
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.




offset_P (1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Sum with maximum

[B Sharma]

Please try the simplest one... 
=SUMIF(C2:C15,"<="&6500)+COUNTIFS(C2:C15,">6500")*6500

On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote:
>
> Dear Sir,
>
> I have a data in Range (C2:C50).  There are values.  I want to sum all 
> value upto or equal to 6500, wherein values greater than 6500 will be 
> treated as 6500.  Kindly help me for formula.
> Regards,
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ How to repair corrupted Excel file

[B Sharma]

Dear Friends & Excel Experts,
I have a Excel 2007 file of around 5 MB (which I saved in binary format. 
Last week it suddenly got corrupted and I am now unable to open it ,

While opening it says "The work book cannot be opened or repaired by MS 
Excel because it is corrupt"

Please help me in this, its one of the important file of mine.

Secondly, please also tell me what are the risks of keeping excel files in 
binary format.
I save some file to reduce the file size.. 

I have tried, "Open & Repair" option. I have also downloaded some 
application which says that they can repair the excel file, but didn;t.


Thanks in advance.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Nokia PC Suit API !!

[B Sharma]

Hiii Rajan,
Please find the link..
http://www.developer.nokia.com/Resources/Tools_and_downloads/Other/PC_Connectivity_API/
 

Hope that you are searching for the same.


On Sunday, July 8, 2012 10:06:36 PM UTC+5:30, Rajan_Verma wrote:
>
> *Hi Group,*
>
> * *
>
> *I am searching for PC Suit API, if anybody have any good link where I 
> can download , please revert, I have google it but failed*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>  
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ VBA Code for inserting a row in table in protected sheet

[B Sharma]

I am Zero in VBA Macros but attracted toward them just because i know excel 
formulas has limitations.
I want to understand the code written by Noorain Bhai..,,

Secondly, the code by Don is perfect for me but there is a problem, i.e. It 
add a row in the sheet , not in the table only.

So suppose if I have two tables in a sheet then it will delete the row from 
each of the tables.

Thanks..



On Saturday, July 7, 2012 11:45:32 AM UTC+5:30, B Sharma wrote:
>
> Wow,
> Great,
> Marvellous,
>
>
> I gets excited when I see the beauty of Macros...
> A combination of few words can do a lot for you.
> Thanks to everyone, Ansari, Asa, Tag & the one whose macro i have applied 
> ie.. Don
>
> Thanks
>
> On Friday, July 6, 2012 7:06:37 PM UTC+5:30, Don Guillett wrote:
>>
>>   You could just allow row insertion option before protecting or
>>  
>>  
>> ActiveSheet.Unprotect Password:="Don"
>>   Rows(ActiveCell.Row).Insert
>> ActiveSheet.Protect Password:="Don"
>>  
>>  
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>>   
>>  *From:* NOORAIN ANSARI  
>> *Sent:* Friday, July 06, 2012 7:02 AM
>> *To:* excel-macros@googlegroups.com 
>> *Subject:* Re: $$Excel-Macros$$ VBA Code for inserting a row in table in 
>> protected sheet
>>  
>> Dear BS,
>>
>> Please try it, change some line as per your exact need.
>>
>> Sub InsertSpecificRows()
>> Dim InsQuan As Integer
>> On Error Resume Next
>> InsQuan = InputBox("Enter number of rows to insert", "Your Call")
>> If InsQuan <= 0 Then
>> MsgBox "Invalid number entered", vbCritical, "Stop!"
>> Exit Sub
>> End If
>> Application.ScreenUpdating = False
>> Do Until Selection.Value = ""
>> ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select
>> Selection.Insert Shift:=xlDown
>> ActiveCell.Offset(InsQuan, 0).Select
>> Loop
>> [A1].Select
>> Application.ScreenUpdating = True
>> End Sub
>>
>>
>> On Fri, Jul 6, 2012 at 5:15 PM, B Sharma  wrote:
>>
>>> Dear Excel Experts, 
>>>  
>>> I have a protected data sheet, where I want to insert row where the 
>>> cursor is selected.
>>>  
>>> I need a VBA code who will do the following: 
>>> 1. Unprotect the sheet (with password)
>>> 2. Insert a row in the table where the cursor is pointed.
>>> 3. Protect the sheet (with password)
>>>  
>>> I need the same to for deleting a row (with confirmation)
>>>  
>>> Please help , I have searched everywhere on net but didnt find any..
>>>  
>>> Thanks & Regards,
>>> BS
>>> -- 
>>> FORUM RULES (986+ members already BANNED for violation)
>>>  
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>>> will not get quick attention or may not be answered.
>>>  
>>> 2) Don't post a question in the thread of another member.
>>>  
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>>  
>>> 4) Acknowledge the responses you receive, good or bad.
>>>  
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>>> signatures are prohibited. 
>>>  
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>>  
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>  
>>> To unsubscribe, send a blank email to 
>>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>>
>>
>>
>>
>> -- 
>> Thanks & regards,
>> Noorain Ansari
>> www.noorainansari.com 
>> www.excelmacroworld.blogspot.com
>>
>>
>>
>>  
>>
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post question

Re: $$Excel-Macros$$ VBA Code for inserting a row in table in protected sheet

[B Sharma]

Wow,
Great,
Marvellous,


I gets excited when I see the beauty of Macros...
A combination of few words can do a lot for you.
Thanks to everyone, Ansari, Asa, Tag & the one whose macro i have applied 
ie.. Don

Thanks

On Friday, July 6, 2012 7:06:37 PM UTC+5:30, Don Guillett wrote:
>
>   You could just allow row insertion option before protecting or
>  
>  
> ActiveSheet.Unprotect Password:="Don"
>   Rows(ActiveCell.Row).Insert
> ActiveSheet.Protect Password:="Don"
>  
>  
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* NOORAIN ANSARI  
> *Sent:* Friday, July 06, 2012 7:02 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* Re: $$Excel-Macros$$ VBA Code for inserting a row in table in 
> protected sheet
>  
> Dear BS,
>
> Please try it, change some line as per your exact need.
>
> Sub InsertSpecificRows()
> Dim InsQuan As Integer
> On Error Resume Next
> InsQuan = InputBox("Enter number of rows to insert", "Your Call")
> If InsQuan <= 0 Then
> MsgBox "Invalid number entered", vbCritical, "Stop!"
> Exit Sub
> End If
> Application.ScreenUpdating = False
> Do Until Selection.Value = ""
> ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select
> Selection.Insert Shift:=xlDown
> ActiveCell.Offset(InsQuan, 0).Select
> Loop
> [A1].Select
> Application.ScreenUpdating = True
> End Sub
>
>
> On Fri, Jul 6, 2012 at 5:15 PM, B Sharma  wrote:
>
>> Dear Excel Experts, 
>>  
>> I have a protected data sheet, where I want to insert row where the 
>> cursor is selected.
>>  
>> I need a VBA code who will do the following: 
>> 1. Unprotect the sheet (with password)
>> 2. Insert a row in the table where the cursor is pointed.
>> 3. Protect the sheet (with password)
>>  
>> I need the same to for deleting a row (with confirmation)
>>  
>> Please help , I have searched everywhere on net but didnt find any..
>>  
>> Thanks & Regards,
>> BS
>> -- 
>> FORUM RULES (986+ members already BANNED for violation)
>>  
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>>  
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>  
>> To unsubscribe, send a blank email to 
>> mailto:excel-macros%2bunsubscr...@googlegroups.com
>
>
>
>
> -- 
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com 
> www.excelmacroworld.blogspot.com
>
>
>
>  
>
> -- 
> FORUM RULES (986+ members already BANNED for violation)
>  
> 1) Use concise, accurate thread titles. Poor thread titles, like Please 
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice 
> will not get quick attention or may not be answered.
>  
> 2) Don't post a question in the thread of another member.
>  
> 3) Don't post questions regarding breaking or bypassing any security 
> measure.
>  
> 4) Acknowledge the responses you receive, good or bad.
>  
> 5) Cross-promotion of, or links to, forums competitive to this forum in 
> signatures are prohibited. 
>  
> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
> owners and members are not responsible for any loss.
>  
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>  
> To unsubscribe, send a blank email to 
> excel-macros+unsubscr...@googlegroups.com
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post

$$Excel-Macros$$ Re: VBA Code for inserting a row in table in protected sheet

[B Sharma]

Dear Friend Noorain,
Thanks for your quick reply...

I tried this but failed, I was unable to insert rows in the table.
I have attached a file for your reference too.

Please see and help.

BS


On Friday, July 6, 2012 5:15:20 PM UTC+5:30, B Sharma wrote:
>
> Dear Excel Experts,
>
> I have a protected data sheet, where I want to insert row where the cursor 
> is selected.
>
> I need a VBA code who will do the following: 
> 1. Unprotect the sheet (with password)
> 2. Insert a row in the table where the cursor is pointed.
> 3. Protect the sheet (with password)
>
> I need the same to for deleting a row (with confirmation)
>
> Please help , I have searched everywhere on net but didnt find any..
>
> Thanks & Regards,
> BS
>

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Insert Row in protected sheet.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ VBA Code for inserting a row in table in protected sheet

[B Sharma]

Dear Excel Experts,

I have a protected data sheet, where I want to insert row where the cursor 
is selected.

I need a VBA code who will do the following: 
1. Unprotect the sheet (with password)
2. Insert a row in the table where the cursor is pointed.
3. Protect the sheet (with password)

I need the same to for deleting a row (with confirmation)

Please help , I have searched everywhere on net but didnt find any..

Thanks & Regards,
BS

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

$$Excel-Macros$$ Formula required for finding Consumption value for giving cons. Qty.

[B Sharma]

Dear Friends and excel experts,,

I have a sheet in which there are columns like "Qty""Rate" of purchase 
of items,
In Another sheet I need a formula for auto calculation of consumption value 
of goods for the given quantity in FIFO method (First In First Out)

I have tried all my known tricks, but failed..

Please help.

Thanks & Regards,
BS

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Formula for multiplication on FIFO method.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Pivot Table from two separate sheets

[B Sharma]

Hello Friends.
I have two sheets For E.g.
1. Opening Balances and purchases of goods
2. Consumption of goods

Both the sheets will contain many colours like.
purchase date,consumption date,  inv. no. party name., item, qty. ,
values, etc.



Now I need to create a Pivot table, in which it will look like
this

Month  -  Op. Bal. - Purchase - Consumption - Cl.Bal.

I need to import the data from two separate sheets here and show
report in one report.

Thanks & Regards,
BS

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Rajan verma : Most Helpful Member- Dec'2011

[B Sharma]

Hey Rajan,

Congratulations to you on this achievement.
Hope this year will be fantastic for you and "you will add a member in
your family soon."

Thanks & Regards,
BS


On Jan 3, 11:20 pm, Ayush Jain  wrote:
> Hello Everyone,
>
> Wish you a very happy new year !!
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> December'2011
> He has posted 105 posts in December2011 and helped many people through his
> expertise. He has been consistent contributor to this excel forum and has
> acheived this recognition third time.
>
> He is back after long time but we all want him to continue his voluntary
> contribution in 2012 as well.
>
> Thanks to Don, Noorain, and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
>
> Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Happy Birth Day

[B Sharma]

Happy Birthday Noorain
and thanks to Rajan for this info..


God bless both of you and whatever is your dream you achieve that.

Thanks & Regards,
BS

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Working in multiple workbooks

[B Sharma]

Dear friends
thanks for replyinng

But I havrent got my solution




On Dec 3, 11:19 pm, NOORAIN ANSARI  wrote:
> Dear B. Sharma,
>
> Read this article or use VBA Macro mentioned 
> thereby:-http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
>
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
>
>
>
> On Sat, Dec 3, 2011 at 10:31 AM, B Sharma  wrote:
> > Dear Excel Experts...
>
> > I have created two separate work book.
> > 1st one is the  database and 2nd one is the report / summary file
>
> > now my query is that while checking the reports I dont want to open
> > the database file ,, currently I have to open both file for working.
>
> > Is there any easy way.
>
> > 2ndly please give some tips so that I can minimize the size of the
> > workbook.
>
> > --
> > FORUM RULES (934+ members already BANNED for violation)
>
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> > will not get quick attention or may not be answered.
>
> > 2) Don't post a question in the thread of another member.
>
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
>
> > 4) Acknowledge the responses you receive, good or bad.
>
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
>
> > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
>
> > --- 
> > ---
> > To post to this group, send email to excel-macros@googlegroups.com
>
> --

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Working in multiple workbooks

[B Sharma]

Dear Excel Experts...

I have created two separate work book.
1st one is the  database and 2nd one is the report / summary file

now my query is that while checking the reports I dont want to open
the database file ,, currently I have to open both file for working.

Is there any easy way.

2ndly please give some tips so that I can minimize the size of the
workbook.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Data validation not working properly

[B Sharma]

Dear Excel Experts.

I have created a drop down list using data validation and the source
of the list is a dynamic range created at another sheet.

I have checked "Show error alert after invalid data entered"

Its working fine and showing the source list in the drop down list but
it also accepts any other enteries made which are not part of that
list.

Please help me why its happening..

Thanks & Regards
BS

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

[B Sharma]

Dear Don & other experts

Coloumn A has raw data and column B have sorted data
Before  After
52  193 
86  195 
92C 52 
94B 86 
94B 87 
195 92C 
193 94B 
ABC 94C 
XYZ 94J 
87  94K 
94J ABC 
94B XYZ 
94K 
94C 


Hope that you can understand...
Thanks 7 Regards,
BS




On Oct 13, 9:01 pm, "dguillett1"  wrote:
> What would the AFTER look like
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: B Sharma
> Sent: Thursday, October 13, 2011 8:46 AM
> To: MS EXCEL AND VBA MACROS
> Cc: rajanverma1...@gmail.com
> Subject: $$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)
>
> Dear Excel Experts  (and to my friends who have answered to my
> earlier queries)
>
> From a long time, I am searching for a formula which can sort the list
> and represent the unique datas only
>
> for Example , In column 1 I have the following data
>
> 52
> 86
> 92C
> 94B
> 94B
> 195
> 193
> ABC
> XYZ
> 87
> 94J
> 94B
> 94K
> 94C
>
> like this...
> I want a output in column B where it will ignore the duplicate items
> and sorted figures.
>
> I think its quiet difficult but please try this ...
>
> Thanks & Regards,
> B. Sharma
>
> --
> --- 
> ---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Formula Sorting Data (Alpha + Numeric)

[B Sharma]

Dear Excel Experts  (and to my friends who have answered to my
earlier queries)

>From a long time, I am searching for a formula which can sort the list
and represent the unique datas only

for Example , In column 1 I have the following data

52
86
92C
94B
94B
195
193
ABC
XYZ
87
94J
94B
94K
94C

like this...
I want a output in column B where it will ignore the duplicate items
and sorted figures.

I think its quiet difficult but please try this ...

Thanks & Regards,
B. Sharma

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

[B Sharma]

Thanks to all . almost every formula is working 

Actually my problem is the following
I have 3 coloums

"Rate w.e.f.
(dd-mmm-yy)"Item Rate

01-Apr-10  Bulb  5.00
15-Apr-10  Bulb  6.00
01-Jul-10  Bulb  7.00
30-Jul-10  Bulb  8.00
15-Aug-10  Bulb  9.00
31-Oct-10  Bulb  10.00
01-Apr-10  Light 11.00
15-Apr-10  Light 12.00
01-Jul-10  Light 13.00
30-Jul-10  Light 14.00
15-Aug-10  Light 15.00
31-Oct-10  Light 16.00
01-Apr-10  Switch 17.00
15-Apr-10  Switch 18.00
01-Jul-10  Switch19.00
30-Jul-10  Switch20.00
15-Aug-10  Switch21.00
31-Oct-10  Switch22.00

I can sort the above columns as and when required

So In Column DEF I have the following criterias...
Date Item  Rate(Formula)
14-Aug-10 Switch  14

The formula for column F is the following...
=SUMPRODUCT((A1:A18=SUMPRODUCT(MAX(($A$1:$A$18<=K7)*($A$1:$A
$18*(B1:B18=L7)*(C1:C18))

Do anyone have any other small formula (i need because I have to
add this formula with other formulas in a very large database)

Thanks & Regards,

PLease also tell me why there is no option to attach files here... how
the other users are attaching their files.

BS





On Oct 13, 12:23 am, Dilip Pandey  wrote:
> Hi,
>
> Use the formula :-
> =OFFSET($A$1,MATCH($B$1,$A$1:$A$6,1)-1,0)
>
> Sample worksheet is also attached for your ready reference.  Let me
> know if this suits your requirements.
>
> Regards,
> DILIPandey
>
> On 10/12/11, B Sharma  wrote:
>
>
>
>
>
>
>
>
>
> > Dear Excel Experts
> > I want to select a date which is either equals to or lesser than the
> > select date.
>
> > For Example
>
> > in Column 1 I have different dates
>
> > 01-Apr-2010
> > 01-Jul-2010
> > 15-Aug-2010
> > 01-Oct-2010
> > 15-Nov-2010
> > 08-Aug-2010
>
> >  (sorted and un sorted both)
>
> > In Cell B2 I have entered a date, say.  15-Sep-2010
> > In Cell C3 I want a formula which will return the date either equals
> > to B2 or 1 time lesser than it.
> > In this case the result will be 15-Aug-2010
>
> > Please help its very urgent
>
> > --
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY, mvp
>        MBA,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>  Selecting equal or less date by DILIPandey.xlsx
> 12KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

[B Sharma]

Hi Sanjib ... can you please send me your email id so that i can
send you a sample file..




On Oct 12, 5:02 pm, Sanjib Chatterjee 
wrote:
> B. sharma.
>
> goto vba = module1=>paste the code
>
> in excel write a date = inset the function from userdefined function
>
> Sanjib
>
>
>
>
>
>
>
> On Wed, Oct 12, 2011 at 4:43 PM, B Sharma  wrote:
> > Dear Sanjib.
> > there is no option there to attach the file
> > please help
>
> > On Oct 12, 12:16 pm, Sanjib Chatterjee 
> > wrote:
> > > dear
> > > B Sharma
> > > please send me the sheets
>
> > > sanjib
>
> > > On Wed, Oct 12, 2011 at 12:37 PM, B Sharma  wrote:
> > > > Dear Excel Experts
> > > > I want to select a date which is either equals to or lesser than the
> > > > select date.
>
> > > > For Example
>
> > > > in Column 1 I have different dates
>
> > > > 01-Apr-2010
> > > > 01-Jul-2010
> > > > 15-Aug-2010
> > > > 01-Oct-2010
> > > > 15-Nov-2010
> > > > 08-Aug-2010
>
> > > >  (sorted and un sorted both)
>
> > > > In Cell B2 I have entered a date, say.  15-Sep-2010
> > > > In Cell C3 I want a formula which will return the date either equals
> > > > to B2 or 1 time lesser than it.
> > > > In this case the result will be 15-Aug-2010
>
> > > > Please help its very urgent
>
> > > > --
>
> > ---
> > ---
> > > > Some important links for excel users:
> > > > 1. Follow us on TWITTER for tips tricks and links :
> > > >http://twitter.com/exceldailytip
> > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > > <><><><><><><><><><><><><><><><><><><><><><>
> > > > Like our page on facebook , Just follow below link
> > > >http://www.facebook.com/discussexcel
>
> > --
>
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

[B Sharma]

Dear Sanjib.
there is no option there to attach the file
please help


On Oct 12, 12:16 pm, Sanjib Chatterjee 
wrote:
> dear
> B Sharma
> please send me the sheets
>
> sanjib
>
>
>
>
>
>
>
> On Wed, Oct 12, 2011 at 12:37 PM, B Sharma  wrote:
> > Dear Excel Experts
> > I want to select a date which is either equals to or lesser than the
> > select date.
>
> > For Example
>
> > in Column 1 I have different dates
>
> > 01-Apr-2010
> > 01-Jul-2010
> > 15-Aug-2010
> > 01-Oct-2010
> > 15-Nov-2010
> > 08-Aug-2010
>
> >  (sorted and un sorted both)
>
> > In Cell B2 I have entered a date, say.  15-Sep-2010
> > In Cell C3 I want a formula which will return the date either equals
> > to B2 or 1 time lesser than it.
> > In this case the result will be 15-Aug-2010
>
> > Please help its very urgent
>
> > --
>
> > --- 
> > ---
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

[B Sharma]

Dear Excel Experts
I want to select a date which is either equals to or lesser than the
select date.

For Example

in Column 1 I have different dates

01-Apr-2010
01-Jul-2010
15-Aug-2010
01-Oct-2010
15-Nov-2010
08-Aug-2010

 (sorted and un sorted both)

In Cell B2 I have entered a date, say.  15-Sep-2010
In Cell C3 I want a formula which will return the date either equals
to B2 or 1 time lesser than it.
In this case the result will be 15-Aug-2010


Please help its very urgent

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

[B Sharma]

Yes Rajan,
You are right  I am using the same for the time being...
but I wanted to use this through Dsum... anyways ... thanks for your
time...






On Aug 30, 7:32 pm, "Rajan_Verma"  wrote:
> Hi Bajrang,
> You can use sumifs() Function for this I think, or attached a sample file to
> better understand your Query,
>
> Rajan.
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of B Sharma
> Sent: Tuesday, August 16, 2011 12:53 PM
> To: MS EXCEL AND VBA MACROS
> Cc: rajanverma1...@gmail.com
> Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...
>
> Hello to Excel Experts and other users of this group.
>
> I've been looking everywhere   about how to put several criteria in
> different cell ranges in:
>
> DSUM(database, field, criteria).
>
> I have a very large database and using Dsum and I am using different
> different criteria  in different different columns.
>
> Normally you put for example A1:G2 and everything works fine. Now the
> problem is that I have quite many criterias that are common for
> several DSUM() and I would like to split the criterias into for
> example A1:D2 and G1:G2.
>
> I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
> with refernces..),
> DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.
>
> What can I do?
>
> If anyone has an idea please let me know !!
>
> B. Sharma
>
> --
> --- -
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ UDF needed urgently..

[B Sharma]

Hello to every excel expert

I very very urgently needed a UDF which will enhance the possibilities
of giving criterias in the function DSUM

For Example
Dsum(database,field,criteria)
currently I am able to select like this dsum(A1:J100,C1,M1:R2)

that means only 1 field can be selected and one series of criteria can
be given

Now I want I can select more than one field at a time and more
criterias located at different places.

Please help me out as early as possible as I am going to Kolkata on
Monday and have to submit a large database and i think this UDF will
help me a lot...

--
Thanks & Regards,
B. Sharma

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ How to use Multiple criteria in DSUM function...

[B Sharma]

Hello to Excel Experts and other users of this group.

I've been looking everywhere   about how to put several criteria in
different cell ranges in:

DSUM(database, field, criteria).

I have a very large database and using Dsum and I am using different
different criteria  in different different columns.

Normally you put for example A1:G2 and everything works fine. Now the
problem is that I have quite many criterias that are common for
several DSUM() and I would like to split the criterias into for
example A1:D2 and G1:G2.

I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
with refernces..),
DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.

What can I do?

If anyone has an idea please let me know !!

B. Sharma

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

[B Sharma]

Congrats to my lovely friend.. Hey Rajan... carry on your
social work dude.

On Aug 5, 11:08 pm, Manish  wrote:
> CongratulationsRajan... :)
>
> -
> Manish
>
> On Aug 5, 9:37 pm, neil johnson  wrote:
>
>
>
>
>
>
>
> > CongratulationRajan.
>
> > On Fri, Aug 5, 2011 at 8:57 AM, Haseeb Avarakkan 
> > > wrote:
> > > CongratulationsRajan...!
>
> > > Regards, Haseeb
>
> > > --
>
> > > ---
> > >  ­---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > > To post to this group, send email to excel-macros@googlegroups.com
>
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel-Hide quoted text -
>
> > - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to learn VBA Languages and Macros

[B Sharma]

Hey Susan,,

If you have that book then please send it to my email address or
attach here...


my email address issharma(dot)ctc(at the rate)gmail(dot)com

Thanks & Regards,
B. Sharma

On Dec 30 2010, 9:43 pm, "Susan"  wrote:
> I useExcel2007 Visual Basic for Applications, Step by Step.  This book was
> extremely helpful to me as I am a new in learning VB and wanted to write
> more extensive macros.
>
> Susan
>
>
>
>
>
>
>
> -Original Message-
> From:excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
>
> On Behalf Of B Sharma
> Sent: Thursday, December 30, 2010 3:13 AM
> To: MSEXCELANDVBAMACROS
> Subject: $$Excel-Macros$$ How to learnVBALanguages and Macros
>
> Dear Friends,
> Firstly I want to thank you all for making and using this wonderful
> educational site. Its really superb.
>
> I am somewhat good inexcelinbuilt formulas & functions and able to
> complete most of my work through that.
>
> But I need your help as I want to learnVBAprogramming& Macros and
> want to automate my working.
>
> Please suggest me the way, I want to know how to write programs
> starting with some small programs in a easy language along with the
> meaning /definition of objects, array, classes, etc.
> How to write programmes.
>
> Along with this I will appreciate if peoples send me their working
> files, learning books, etc. through which I can learn programmes, etc.
>
> --
> --- -
> --
> Some important links forexcelusers:
> 1. Follow us on TWITTER for tips tricks and links 
> :http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> 3.Exceltutorials athttp://www.excel-macros.blogspot.com
> 4. LearnVBAMacros athttp://www.quickvba.blogspot.com
> 5.ExcelTips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email toexcel-mac...@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: How to use a drop down list to select data from another sheet

[B Sharma]

H Steve,
No attachment found,,..
Please send your attachment and then we will try to answer.

Thanks & Regards,
BS (sharma@gmail.com)

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ How to learn VBA Languages and Macros

[B Sharma]

Dear Friends,
Firstly I want to thank you all for making and using this wonderful
educational site. Its really superb.

I am somewhat good in excel inbuilt formulas & functions and able to
complete most of my work through that.

But I need your help as I want to learn VBA programming & Macros and
want to automate my working.

Please suggest me the way, I want to know how to write programs
starting with some small programs in a easy language along with the
meaning /definition of objects, array, classes, etc.
How to write programmes.

Along with this I will appreciate if peoples send me their working
files, learning books, etc. through which I can learn programmes, etc.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts