$$Excel-Macros$$ Re: Excel to Access Data
Thanks Noorain. I couldn't reply in time as I was not keeping well. I worked with the procedure suggested by Swapnil and moved ahead. And now I got an obstruction. In the excel sheet, I am using an combo-box and want to populate the combo-box with 'Items' category in the Access Database. The 'Items' re-occur in the database, so i need to populate the combo-box with unique Items only. I suppose I can do this by clicking the property of the Access Query. Please help. Regards, Wireless On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote: > > Hi All, > > I am trying to relate Access data & queries to excel. The excel will be > the user interface. This excel will contain the various buttons to get > specific informations and clicking these buttons will fetch the data from > the access table or queries. > > Please suggest how it can be done. > > Sincere regards, > Wireless > -- 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.
Re: $$Excel-Macros$$ Re: Count multiple criteria in a column with the help of VBA
thanks bhai
But want to solution in VBA.
On Thu, Sep 13, 2012 at 10:49 AM, Prince Dubey wrote:
> Hi Jeet,
>
> Please use below formula hope this will helpe you.
>
>
> =SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13)))
> use it with Ctr+Shift+Enter
>
> Regards
> Prince
>
> On Wednesday, September 12, 2012 11:52:11 PM UTC+5:30, jeet singh wrote:
>>
>> Dear all,
>>
>> I want to count multiple criteria in a column. I have done this query in
>> excel, Formula have given below.
>>
>> =SUM(COUNTIFS(Sheet1!C:C,**Sheet2!A2,Sheet1!E:E,{12,13}))
>>
>> Regards
>>
>>
>> --
> 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.
>
>
>
--
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: Count multiple criteria in a column with the help of VBA
Hi Jeet,
Please use below formula hope this will helpe you.
=SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13)))
use it with Ctr+Shift+Enter
Regards
Prince
On Wednesday, September 12, 2012 11:52:11 PM UTC+5:30, jeet singh wrote:
>
> Dear all,
>
> I want to count multiple criteria in a column. I have done this query in
> excel, Formula have given below.
>
> =SUM(COUNTIFS(Sheet1!C:C,Sheet2!A2,Sheet1!E:E,{12,13}))
>
> Regards
>
>
>
--
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.
Re: $$Excel-Macros$$ Re: Stock management software in excel
Hi Sagar, I think you can use any open source ERP that help you to manage all your need Thanks, Sushil On Thu, Sep 13, 2012 at 9:48 AM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Prince, > > I required the FIFO method stock maintain in Excel. > > Thanks & Regards, > Sagar > > On Tue, Sep 11, 2012 at 9:47 PM, Prince Dubey wrote: > >> Hi Sagar, >> >> I think stock management criteria for several firms or companies could be >> different so pleas explain requirements (functionality as u require) to be >> in ur macro. >> >> regards >> prince >> >> On Tuesday, September 11, 2012 11:04:42 AM UTC+5:30, >> ca_k...@yahoo.co.inwrote: >>> >>> Dear all, >>> >>> Any stock management macro in excel then Please give me the same. >>> >>> Thanks & Regards, >>> Sagar Kasangottuwar >>> >> -- >> 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. >> >> >> > > -- > 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. > > > -- 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.
Re: $$Excel-Macros$$ Re: Stock management software in excel
Dear Prince, I required the FIFO method stock maintain in Excel. Thanks & Regards, Sagar On Tue, Sep 11, 2012 at 9:47 PM, Prince Dubey wrote: > Hi Sagar, > > I think stock management criteria for several firms or companies could be > different so pleas explain requirements (functionality as u require) to be > in ur macro. > > regards > prince > > On Tuesday, September 11, 2012 11:04:42 AM UTC+5:30, ca_k...@yahoo.co.inwrote: >> >> Dear all, >> >> Any stock management macro in excel then Please give me the same. >> >> Thanks & Regards, >> Sagar Kasangottuwar >> > -- > 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. > > > -- 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.
Re: $$Excel-Macros$$ Rank Formula.........
> > Hi Dhananjay, > > Please Find the Attachment. > Regards, > > Excel Beginner > > > I need a solution as per my query in attached file. >> >> Pl. revert in case of any clarification or any confusion. >> >> Regards, >> Dhananjay >> >> -- >> 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. >> >> >> > > > -- > *Regards,* > * > * > *Excel Beginner* > > -- *Regards,* * * *Excel Beginner* -- 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. Rank2 (solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Rank Formula.........
Hi Dhananjay, Please find the attachment. Regards, Excel Beginner On Mon, Sep 10, 2012 at 12:32 AM, Dhananjay Pinjan wrote: > Dear Experts, > > I need a solution as per my query in attached file. > > Pl. revert in case of any clarification or any confusion. > > Regards, > Dhananjay > > -- > 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. > > > -- *Regards,* * * *Excel Beginner* -- 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. Rank1(solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Rank Formula.........
Hi Mr. David / Excel Experts, I am very impressed the way you have given answer. I was expecting the use of formula "RANK' or 'SUMPRODUCT'. But you have just given it with very simple equtions. Hat's off. Sorry to say, but I have some modifications in my requirements (pl. refer attached Excel File for revised query). Pl. help. Regards, Dhananjay On 9/10/12, Dhananjay Pinjan wrote: > Wow!!! Thanks. > > On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon > wrote: > >> See attached >> >> On 10 September 2012 05:02, Dhananjay Pinjan wrote: >> > Dear Experts, >> > >> > I need a solution as per my query in attached file. >> > >> > Pl. revert in case of any clarification or any confusion. >> > >> > Regards, >> > Dhananjay >> > >> > -- >> > 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. >> > >> > >> >> >> >> -- >> Regards >> David Grugeon >> >> -- >> 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. >> >> >> > -- 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. Rank2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
Hertiest Congrats Noorain Ansari. Do continue. Best Luck On 9/12/12, SAGAR KASANGOTTUWAR wrote: > Congratulations Noorain... > > Best Regards, > > sagar > > On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon > wrote: > >> Loveufe2001 >> >> I suggest you post your question in its own thread and try to give a >> bit more of an explanation of what you are doing Also use a suitable >> heading. >> >> On 11 September 2012 18:20, loveufe2001 wrote: >> > >> > Dear friends: >> > My question is :when I closed Thisworkbook I Need the project's >> > password ?But if I query data by the model's code ,it's ok. >> > Thanks! >> > ps: the password is "sa" >> > >> > >> > >> > -- >> > 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. >> > >> > >> >> >> >> -- >> Regards >> David Grugeon >> >> -- >> 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. >> >> >> > > -- > 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. > > > -- 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
Re: $$Excel-Macros$$ Count multiple criteria in a column with the help of VBA
Or another alternative
=SUMPRODUCT((Sheet1!$A$2:$A$2270=A2)*((Sheet1!$B$2:$B$2270=12)+(Sheet1!$B$2:$B$2270=13)))
Sub cnt()
Dim rng As Range
Dim rng1 As Range
Dim i As Integer
Set rng = Sheet1.Range("A2:A" & Sheet1.Range("A" &
Rows.Count).End(xlUp).Row)
Set rng1 = Sheet1.Range("B2:B" & Sheet1.Range("B" &
Rows.Count).End(xlUp).Row)
For i = 2 To Sheet2.Range("A" & Rows.Count).End(xlUp).Row
Sheet2.Cells(i, 2).Value = Evaluate("=SUMPRODUCT((" & rng.Address(, , ,
True) & "=A" & i & ")*((" & rng1.Address(, , , True) & "=12)+(" &
rng1.Address(, , , True) & "=13)))")
Next
End Sub
Regards,
Sam Mathai CHacko
On Thu, Sep 13, 2012 at 12:15 AM, Paul Schreiner wrote:
> I believe that the problem is that, when you enter the formula in the
> Workbook,
> you're entering it as an "ARRAY" formula, where it matches the value in
> Column A
> and column B is EITHER 12 or 13 ({12,13})
>
> But in your VBA, you're only counting a match of 12:
>
> Sheet2.Cells(i, 2) = WorksheetFunction.CountIfs(rng, Cells(i, 1), rng1,
> "12")
>
> I don't believe that the VBA WorksheetFunction is going to allow you to
> enter an array function.
> I think you're going to have to add them like:
>
> Sheet2.Cells(i, 2) = WorksheetFunction.CountIfs(rng, Cells(i, 1), rng1,
> "12") _
>+ WorksheetFunction.CountIfs(rng, Cells(i, 1),
> rng1, "13")
>
> I changed the VBA and result matches column "C".
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
> --
> *From:* jeet singh
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, September 12, 2012 2:32:12 PM
> *Subject:* $$Excel-Macros$$ Count multiple criteria in a column with the
> help of VBA
>
> Dear all,
>
> I want to count multiple criteria in a column. I have done this query in
> excel, Formula have given below.
>
> =SUM(COUNTIFS(Sheet1!C:C,Sheet2!A2,Sheet1!E:E,{12,13}))
>
> Regards
>
>
> --
> 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.
>
>
>
> --
> 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.
>
>
>
--
Sam Mathai Chacko
--
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 quest
Re: $$Excel-Macros$$ Count multiple criteria in a column with the help of VBA
I believe that the problem is that, when you enter the formula in the Workbook,
you're entering it as an "ARRAY" formula, where it matches the value in Column A
and column B is EITHER 12 or 13 ({12,13})
But in your VBA, you're only counting a match of 12:
Sheet2.Cells(i, 2) = WorksheetFunction.CountIfs(rng, Cells(i, 1), rng1, "12")
I don't believe that the VBA WorksheetFunction is going to allow you to enter
an
array function.
I think you're going to have to add them like:
Sheet2.Cells(i, 2) = WorksheetFunction.CountIfs(rng, Cells(i, 1), rng1, "12") _
+ WorksheetFunction.CountIfs(rng, Cells(i, 1), rng1,
"13")
I changed the VBA and result matches column "C".
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: jeet singh
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 2:32:12 PM
Subject: $$Excel-Macros$$ Count multiple criteria in a column with the help of
VBA
Dear all,
I want to count multiple criteria in a column. I have done this query in excel,
Formula have given below.
=SUM(COUNTIFS(Sheet1!C:C,Sheet2!A2,Sheet1!E:E,{12,13}))
Regards
--
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.
--
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.
Re: $$Excel-Macros$$ Re: UDF to sum range
Hi Kuldeep.. It Doesnt work.. can you show or attach file with solution. Rgds On Wednesday, September 12, 2012 10:40:39 PM UTC+5:30, Kuldeep Singh wrote: > > > Hi, > > Try this. > > Function Udf_sum(rng As Excel.Range) > Dim cell As Range > For Each cell In rng > If VBA.IsNumeric(cell) And cell.Value <> "" Then > Udf_sum = Udf_sum + cell > End If > Next cell > End Function* * > > Regards, > Kuldeep Singh > > On Wed, Sep 12, 2012 at 10:27 PM, Rajan_Verma > > > wrote: > >> * * >> >> * * >> >> *=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4))* >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-...@googlegroups.com [mailto: >> excel-...@googlegroups.com ] *On Behalf Of *Vabz >> *Sent:* 12 September 2012 9:52 >> *To:* excel-...@googlegroups.com >> *Subject:* $$Excel-Macros$$ Re: UDF to sum range >> >> ** ** >> >> hi >> >> ** ** >> >> Question was really tuff..but not impossible.. >> >> ** ** >> >> I could manage to solve without UDF >> >> ** ** >> >> PFA.. Soln is in K column.. >> >> ** ** >> >> Cheerz.. >> >> ** ** >> >> Rgds//Vabz >> >> >> >> On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote: >> >> Hi experts, I need your help, I tried myself but unfortunatly its not >> working. >> I need UDF to sum range. >> 1) first my range will be B4:E4 and >> I am going to drag udf into columns to next range will be C5:E5, >> Means when I will drag my udf function it will increase in range by >> 1column and 1 row >> >> >> >> PFA for more details. >> >> >> >> -- >> 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-...@googlegroups.com >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com . >> >> >> >> -- >> 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-...@googlegroups.com >> . >> To unsubscribe from this group, send email to >> excel-macros...@googlegroups.com . >> > -- 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.
Re: $$Excel-Macros$$ Re: UDF to sum range
Hi, Try this. Function Udf_sum(rng As Excel.Range) Dim cell As Range For Each cell In rng If VBA.IsNumeric(cell) And cell.Value <> "" Then Udf_sum = Udf_sum + cell End If Next cell End Function* * Regards, Kuldeep Singh On Wed, Sep 12, 2012 at 10:27 PM, Rajan_Verma wrote: > * * > > * * > > *=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4))* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Vabz > *Sent:* 12 September 2012 9:52 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: UDF to sum range > > ** ** > > hi > > ** ** > > Question was really tuff..but not impossible.. > > ** ** > > I could manage to solve without UDF > > ** ** > > PFA.. Soln is in K column.. > > ** ** > > Cheerz.. > > ** ** > > Rgds//Vabz > > > > On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote: > > Hi experts, I need your help, I tried myself but unfortunatly its not > working. > I need UDF to sum range. > 1) first my range will be B4:E4 and > I am going to drag udf into columns to next range will be C5:E5, > Means when I will drag my udf function it will increase in range by > 1column and 1 row > > > > PFA for more details. > > > > -- > 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. > > > > -- > 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. > -- 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.
Re: $$Excel-Macros$$ Re: help with creating macro to format list
Sub tests()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.Calculation = xlCalculationManual
Sheets("New").UsedRange.Borders.LineStyle =
Excel.XlLineStyle.xlLineStyleNone
Dim i As Long
For i = 2 To Sheets("New").Range("a65356").End(xlUp).Row
If Sheets("New").Range("a" & i).Value <> Sheets("New").Range("a" & i +
1).Value Then
With Sheets("New").Range("a" & i & ":h" & i).Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
End If
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.Calculation = xlCalculationAutomatic
End Sub
On Wed, Sep 12, 2012 at 6:39 PM, Vabz wrote:
> Hi
>
> I guess i am late but thought of responding..
>
> You can put conditional formatting in cells which you want to underline..
>
> Sample file is attached..
>
> Cheers..
>
> Rgds//Vabz
>
> On Friday, August 31, 2012 2:21:50 AM UTC+5:30, CAN wrote:
>>
>> I have list that goes from column A to colum H
>>
>> on column H it list the subtotals based on dates ranges. Every time
>> there is a change of dates, column H shows the subtotal of amount (Column
>> E). The sheet realizes that the next row will start a new date and it
>> computes a subtotal on cell H and last row for that particular date.
>>
>> What I need is a macro that will look at column H, and every time it
>> finds a value (other than "blank") it will draw a line from column A to
>> column H as shown on the sample below. The line has to be located on the
>> row that shows the last date entry before the date changes to a new day
>>
>> 08/07/12 ANT0306 114.00 56527149 08/07/12 ANT0110 114.00
>> 000208854552 08/07/12 ANT0105 114.00 000x 08/07/12
>> ANT0132 109.00 53745845 * 08/07/12* *ANT0280* *109.00* *
>> 53745846* * 560.00* 08/08/12 ANT0207 114.00 1752
>> *08/08/12* *ANT0013* *114.00* * 1123* * 280.00*
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> I have attached a sample list on Excel, so it shows the list and the
>> cells with the subtotals. In the sample several rows on column H shows a
>> subtotal, the the list could have hundreds of rows, so it needs to loop
>> until there are no more values on column A
>>
>> As always, Thank you very much for all the help
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
> 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.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*
P Before printing, think about the environment.
--
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.
RE: $$Excel-Macros$$ Re: UDF to sum range
=SUM(OFFSET($A4,,ROWS($L$3:L3),1,4)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vabz Sent: 12 September 2012 9:52 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: UDF to sum range hi Question was really tuff..but not impossible.. I could manage to solve without UDF PFA.. Soln is in K column.. Cheerz.. Rgds//Vabz On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote: Hi experts, I need your help, I tried myself but unfortunatly its not working. I need UDF to sum range. 1) first my range will be B4:E4 and I am going to drag udf into columns to next range will be C5:E5, Means when I will drag my udf function it will increase in range by 1column and 1 row PFA for more details. -- 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. -- 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.
Re: $$Excel-Macros$$ Excel vba
I am agree with Paul. This group is the main source of information on Excel and its basics. On Wed, Sep 12, 2012 at 7:40 PM, Paul Schreiner wrote: > I don't mean to be difficult, or unhelpful, or snotty, or seem to be any > other bad description, > but this group is designed to help people that are having difficulty with > VBA macros. > Not necessarily teach VBA from scratch. > > I think one of the BIGGEST lessons any of us need to learn is how to look > for help. > The minute we have a question, we should LOOK for the answer instead of > simply asking someone to provide the answer. > > Many times while looking for an answer to one question, I find the answers > to questions > I didn't know I had (until later!). > > As far as beginner learning, the same question has been asked several > times in the past month in this very forum. > Instead of asking someone else to look up the previous responses, you > should try to look for yourself. > > Simply looking for "learn" in this forum should give you previous > responses with links to sites specializing in teaching beginners. > > > *Paul* > > - > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* Shiva Prasad > *To:* excel-macros@googlegroups.com > *Sent:* Wed, September 12, 2012 9:05:01 AM > *Subject:* $$Excel-Macros$$ Excel vba > > hi team, > > my job profile is mis analyst level, > have experience in excel depth formulas level but i need develops in excel > VBA > I want to learn excel vba , > could any one give help me > > -- > > > > > > Regards, > Shivaprasad K. > > > -- > 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. > > > > -- > 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. > > > -- With regards, *MaNgEsH* -- 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
Re: $$Excel-Macros$$ Re: UDF to sum range
IN J4 TYPE = SUM(OFFSET(A4,0,ROW(A1),1,4)) On Wed, Sep 12, 2012 at 9:52 PM, Vabz wrote: > hi > > Question was really tuff..but not impossible.. > > I could manage to solve without UDF > > PFA.. Soln is in K column.. > > Cheerz.. > > Rgds//Vabz > > > On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote: >> >> Hi experts, I need your help, I tried myself but unfortunatly its not >> working. >> I need UDF to sum range. >> 1) first my range will be B4:E4 and >> I am going to drag udf into columns to next range will be C5:E5, >> Means when I will drag my udf function it will increase in range by >> 1column and 1 row >> >> PFA for more details. >> >> > -- > 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. > > > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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: UDF to sum range
hi Question was really tuff..but not impossible.. I could manage to solve without UDF PFA.. Soln is in K column.. Cheerz.. Rgds//Vabz On Friday, August 17, 2012 11:28:51 AM UTC+5:30, Amol J wrote: > > Hi experts, I need your help, I tried myself but unfortunatly its not > working. > I need UDF to sum range. > 1) first my range will be B4:E4 and > I am going to drag udf into columns to next range will be C5:E5, > Means when I will drag my udf function it will increase in range by > 1column and 1 row > > PFA for more details. > > -- 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. rngQuestion.xls Description: MS-Excel spreadsheet
Re: Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
Congratulations Noorain... Best Regards, sagar On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon wrote: > Loveufe2001 > > I suggest you post your question in its own thread and try to give a > bit more of an explanation of what you are doing Also use a suitable > heading. > > On 11 September 2012 18:20, loveufe2001 wrote: > > > > Dear friends: > > My question is :when I closed Thisworkbook I Need the project's > > password ?But if I query data by the model's code ,it's ok. > > Thanks! > > ps: the password is "sa" > > > > > > > > -- > > 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. > > > > > > > > -- > Regards > David Grugeon > > -- > 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. > > > -- 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.
Re: $$Excel-Macros$$ Excel sheet wise restrictions required for end users
One technique I've used in the past is to use VBA to open a text file in Binary
mode.
With this, you can read the passwords for comparisons.
This password file is then placed on the network and cannot be opened/viewed
by anyone UNLESS THEY WRITE A VBA MACRO.
Of course, you have to protect your VBA project so that it cannot be
reverse-engineered.
But if they cannot see your code, and you avoid calling your password file
something obvious:
("Do not Read - This is a password file.txt" wouldn't do very well)
The likelihood of someone making use of it is REDUCED.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 9:28:53 AM
Subject: Re: $$Excel-Macros$$ Excel sheet wise restrictions required for end
users
All I had to do was unhide the sheet. and the code was not protected
(easily
defeated)
. Even if you had hidden with xlVERYHIDDEN code could unhide.
Although more trouble, you may want to use separate protected workbooks where
security is higher for most users.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Krishnaraddi V. Madolli
Sent: Wednesday, September 12, 2012 8:08 AM
To: excel-macros@googlegroups.com
Cc: Subramani P N
Subject: RE: $$Excel-Macros$$ Excel sheet wise restrictions required for end
users
Hi Pravin,
Please find the attached document prepared as per your requirement. Column B
will give password for each sheet.
Regards,
Krishnaraddi V Madolli.
Data Analytics Team
Sedgwick Claims Management Services, Inc.
Xchanging Towers, SJR iPark,
EPIP Area, Whitefield
Bangalore - 560 066. India.
Direct Line: +1.800.920.9657 Extn 1915
Switchboard: +90-(0)80-3054 Extn 1915
Email: krishnaraddi.mado...@asia.xchanging.com
krishnaraddi.mado...@sedgwickcms.com
www.sedgwickcms.com| The leader in innovative claims and productivity
management solutions
Success is never permanent, Failure is never final, so always do not stop
effort
until your victory makes a history.
Please consider the environment before printing this message
From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Pravin Gunjal
Sent: 09/12/2012 14:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel sheet wise restrictions required for end users
Dear Masters,
In the attached file there are six working sheets in it.
The concerned person will send a mail of this file to his down level for their
working/use.
Sheet 1 is made for the master (which can be seen to all end users). While
others - sheet 2 to sheet 7 (i.e. ASM to SO5) are created for individual
details.
I have used a hyperlink to go to the sub sheets.
>From ASM to SO5 working sheets : the end users are individuals and one should
not see the others data (it should be password protected or any other
restriction may be given).
For an example : If I am a SO4 user then when I click on SO4 button in the
sheet1 before following the link the system should ask a password to open the
SO4 sheet. Otherwise it can be restricted for use.
Please help me out on this issue. If you require any other information from me
please write to me. Thanks a lot !
With regards,
Pravin Gunjal
--
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.
--
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 Advic
Re: $$Excel-Macros$$ Excel vba
I don't mean to be difficult, or unhelpful, or snotty, or seem to be any other bad description, but this group is designed to help people that are having difficulty with VBA macros. Not necessarily teach VBA from scratch. I think one of the BIGGEST lessons any of us need to learn is how to look for help. The minute we have a question, we should LOOK for the answer instead of simply asking someone to provide the answer. Many times while looking for an answer to one question, I find the answers to questions I didn't know I had (until later!). As far as beginner learning, the same question has been asked several times in the past month in this very forum. Instead of asking someone else to look up the previous responses, you should try to look for yourself. Simply looking for "learn" in this forum should give you previous responses with links to sites specializing in teaching beginners. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Shiva Prasad To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 9:05:01 AM Subject: $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- 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. -- 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.
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
And, I wonder why he insists.. Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Wednesday, September 12, 2012 8:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
That's precisely the point!
Because he's wanting to do this with formulas, he's making the solution more
complex than necessary.
A VBA solution would be very neat and tidy (use split to load an array, and
display the array elements in the cells)
A "manual" solution using text-to-Columns is also pretty simple.
However, he INSISTS on an Excel Formula.
Personally, if I needed Excel formulas, would try something like:
Column "B" = LEFT($A1,FIND(",",$A1)-1)
Column "D" =MID($A1,FIND(",",$A1)+1,2)
Column "E" =MID($A1,FIND(",",SUBSTITUTE($A1,",","",1))+2,50)
But I'd prefer to use VBA.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Vabz
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 8:59:52 AM
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote:
Hi Mangesh,
I've read your other replies, and as to why you haven't received a formula
method -- most people don't want to take the trouble on a volunteer basis to
provide a more complex or difficult solution to a given problem when simple
solutions exist. Also in business, the simplest solution is the best value.
But I understand that in learning all aspects of a program, sometimes the
exercise of solving a problem in various ways is useful.
I will provide a formula solution for you. Although it could be solved
several ways, I prefer using an array formula, since it can be written in such
a way that it can handle a string of text with any number of commas, whereas
non-array solutions would be limited to a set maximum. However, even with the
array solution, and even though the array will contain all of the parts of the
text string, you will only see on your spreadsheet as many parts as there are
cells in the area you place the array formula (there are ways to use array
formulas with "too large of arrays" to display on your spreadsheet ,as part of
other formulas, that are useful; for example extracting certain values matching
a condition, or summarizing the data (in your data, you might want to know how
many "Mumbai"s there are, how many "32145"s, etc.), without actually displaying
in multiple columns all the split data.
·Select any cell on row 2 of your spreadsheet, then create the
following defined names using the Name Manager (formulas tab in Excel 2007+).
I recommend making them Sheet-level names rather than the default
Workbook-level.
1. Name
=$A2
2. _Name.Terminated
=Name&","
3. _Name.ColumnIdx
=TRANSPOSE(ROW(INDIRECT("1:"& LEN(_Name.Terminated)-LEN(
SUBSTITUTE(_Name.Terminated,", ","")
4. _Name.StartPositions
=IF(Name.ColumnIdx>1,FIND( CHAR(1),SUBSTITUTE(Name,",",
CHAR(1),_Name.ColumnIdx-1)))+1
5. _Name.StopPositions
=FIND(CHAR(1),SUBSTITUTE(_ Name.Terminated,",",CHAR(1),_ Name.ColumnIdx))-1
6. Name.Columns
=MID(Name,_Name. StartPositions,_Name. StopPositions-_Name. StartPositions+1)
The purpose of using the defined names is to simplify the formula by breaking
it into steps. Insofar as the steps are referred to more than once in the
formula, it should make the formula faster to evaluate too. Name.Columns is
the culmination of our calculation and results in an array containing each
comma-separated value from column A, divided into separate columns.
·To display the column-separated values on your spreadsheet, enter
the following formula in B2:
=Name.Columns
·Then highlight from B2 to the furthest column on row 2 needed to
display the maximum number of values ever expected. For a maximum of 3 values,
highlight B2:D2, or for maximum of 10, B2:K2, etc.
·Then hit F2 (edit cell) and Ctrl-Shift-Enter (confirm array
formula). This confirms a multi-cell array formula over the selected cells.
·Copy the array-entered range from row 2 (e.g. B2:D2) to every other
row in your table.
Hope this is of interest,
Asa
From: excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] On
Behalf Of Mangesh Vimay
Sent: Monday, September 10, 2012 4:04 AM
To: excel-...@googlegroups.com
Subject: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Fri
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
That's precisely the point!
Because he's wanting to do this with formulas, he's making the solution more
complex than necessary.
A VBA solution would be very neat and tidy (use split to load an array, and
display the array elements in the cells)
A "manual" solution using text-to-Columns is also pretty simple.
However, he INSISTS on an Excel Formula.
Personally, if I needed Excel formulas, would try something like:
Column "B" = LEFT($A1,FIND(",",$A1)-1)
Column "D" =MID($A1,FIND(",",$A1)+1,2)
Column "E" =MID($A1,FIND(",",SUBSTITUTE($A1,",","",1))+2,50)
But I'd prefer to use VBA.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Vabz
To: excel-macros@googlegroups.com
Sent: Wed, September 12, 2012 8:59:52 AM
Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote:
Hi Mangesh,
>I've read your other replies, and as to why you haven't received a formula
>method -- most people don't want to take the trouble on a volunteer basis to
>provide a more complex or difficult solution to a given problem when simple
>solutions exist. Also in business, the simplest solution is the best value.
>But I understand that in learning all aspects of a program, sometimes the
>exercise of solving a problem in various ways is useful.
>
>I will provide a formula solution for you. Although it could be solved
>several
>ways, I prefer using an array formula, since it can be written in such a way
>that it can handle a string of text with any number of commas, whereas
>non-array
>solutions would be limited to a set maximum. However, even with the array
>solution, and even though the array will contain all of the parts of the text
>string, you will only see on your spreadsheet as many parts as there are cells
>in the area you place the array formula (there are ways to use array formulas
>with "too large of arrays" to display on your spreadsheet ,as part of other
>formulas, that are useful; for example extracting certain values matching a
>condition, or summarizing the data (in your data, you might want to know how
>many "Mumbai"s there are, how many "32145"s, etc.), without actually
>displaying
>in multiple columns all the split data.
>
>· Select any cell on row 2of your spreadsheet, then create the
>following
>defined names using the Name Manager (formulas tab in Excel 2007+). I
>recommend
>making them Sheet-level names rather than the default Workbook-level.
>1. Name
>=$A2
>2. _Name.Terminated
>=Name&","
>3. _Name.ColumnIdx
>=TRANSPOSE(ROW(INDIRECT("1:"& LEN(_Name.Terminated)-LEN(
>SUBSTITUTE(_Name.Terminated,", ","")
>4. _Name.StartPositions
>=IF(Name.ColumnIdx>1,FIND( CHAR(1),SUBSTITUTE(Name,",",
>CHAR(1),_Name.ColumnIdx-1)))+1
>5. _Name.StopPositions
>=FIND(CHAR(1),SUBSTITUTE(_ Name.Terminated,",",CHAR(1),_ Name.ColumnIdx))-1
>6. Name.Columns
>=MID(Name,_Name. StartPositions,_Name. StopPositions-_Name. StartPositions+1)
>
>The purpose of using the defined names is to simplify the formula by breaking
>it
>into steps. Insofar as the steps are referred to more than once in the
>formula,
>it should make the formula faster to evaluate too. Name.Columnsis the
>culmination of our calculation and results in an array containing each
>comma-separated value from column A, divided into separate columns.
>
>· To display the column-separated values on your spreadsheet, enter the
>following formula in B2:
>=Name.Columns
>
>· Then highlight from B2to the furthest column on row 2 neededto
>display
>the maximum number of values ever expected. For a maximum of 3 values,
>highlight B2:D2, or for maximum of 10, B2:K2, etc.
>· Then hit F2(edit cell) and Ctrl-Shift-Enter(confirm array formula).
>This confirms a multi-cell array formula over the selected cells.
>· Copy the array-entered range from row 2 (e.g. B2:D2) to every other
>row
>in your table.
>
>Hope this is of interest,
>Asa
>
>
>From:excel-...@googlegroups.com [mailto:excel-...@ googlegroups.com] On Behalf
>Of Mangesh Vimay
>Sent: Monday, September 10, 2012 4:04 AM
>To: excel-...@googlegroups.com
>Subject: $$Excel-Macros$$ Need help - To divide the string into three parts
>
>Hi Friends,
>
>I need your help to divide the string into three parts.
>The description and sample is given below :
>Waiting for your response.
>
>Thanks.
>
>
>--
>With regards,
>
>MaNgEsH
>
>--
>Join official facebook page of this forum @ https://www.facebook.com/
>discussexcel
>
>FORUM RULES (1120+ members already BANNED for violation)
>
>1) Use conc
Re: $$Excel-Macros$$ Excel sheet wise restrictions required for end users
All I had to do was unhide the sheet. and the code was not protected (easily defeated) . Even if you had hidden with xlVERYHIDDEN code could unhide. Although more trouble, you may want to use separate protected workbooks where security is higher for most users. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Krishnaraddi V. Madolli Sent: Wednesday, September 12, 2012 8:08 AM To: excel-macros@googlegroups.com Cc: Subramani P N Subject: RE: $$Excel-Macros$$ Excel sheet wise restrictions required for end users Hi Pravin, Please find the attached document prepared as per your requirement. Column B will give password for each sheet. Regards, Krishnaraddi V Madolli. Data Analytics Team Sedgwick Claims Management Services, Inc. Xchanging Towers, SJR iPark, EPIP Area, Whitefield Bangalore - 560 066. India. Direct Line: +1.800.920.9657 Extn 1915 Switchboard: +90-(0)80-3054 Extn 1915 Email: krishnaraddi.mado...@asia.xchanging.com krishnaraddi.mado...@sedgwickcms.com www.sedgwickcms.com | The leader in innovative claims and productivity management solutions Success is never permanent, Failure is never final, so always do not stop effort until your victory makes a history. Please consider the environment before printing this message From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 09/12/2012 14:29 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel sheet wise restrictions required for end users Dear Masters, In the attached file there are six working sheets in it. The concerned person will send a mail of this file to his down level for their working/use. Sheet 1 is made for the master (which can be seen to all end users). While others - sheet 2 to sheet 7 (i.e. ASM to SO5) are created for individual details. I have used a hyperlink to go to the sub sheets. >From ASM to SO5 working sheets : the end users are individuals and one should >not see the others data (it should be password protected or any other >restriction may be given). For an example : If I am a SO4 user then when I click on SO4 button in the sheet1 before following the link the system should ask a password to open the SO4 sheet. Otherwise it can be restricted for use. Please help me out on this issue. If you require any other information from me please write to me. Thanks a lot ! With regards, Pravin Gunjal -- 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. -- 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, a
RE: $$Excel-Macros$$ Excel vba
You have already helped yourself to join this group, With following discussion here , you can start learning macros by Recording Macros , start recording little steps may be help for you. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shiva Prasad Sent: 12 September 2012 6:34 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- 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. -- 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$$ Excel vba
hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- 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.
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
hi..
what i feel is this solution is very complex !!
Rgds//Vabz
On Tuesday, September 11, 2012 7:09:23 AM UTC+5:30, Asa R. wrote:
>
> Hi Mangesh,
>
> I've read your other replies, and as to why you haven't received a formula
> method -- most people don't want to take the trouble on a volunteer basis
> to provide a more complex or difficult solution to a given problem when
> simple solutions exist. Also in business, the simplest solution is the
> best value. But I understand that in learning all aspects of a program,
> sometimes the exercise of solving a problem in various ways is useful.
>
>
>
> I will provide a formula solution for you. Although it could be solved
> several ways, I prefer using an array formula, since it can be written in
> such a way that it can handle a string of text with any number of commas,
> whereas non-array solutions would be limited to a set maximum. However,
> even with the array solution, and even though the array will contain all of
> the parts of the text string, you will only see on your spreadsheet as many
> parts as there are cells in the area you place the array formula (there are
> ways to use array formulas with "too large of arrays" to display on your
> spreadsheet ,as part of other formulas, that are useful; for example
> extracting certain values matching a condition, or summarizing the data (in
> your data, you might want to know how many "Mumbai"s there are, how many
> "32145"s, etc.), without actually displaying in multiple columns all the
> split data.
>
>
>
> ·*Select any cell on row 2* of your spreadsheet, *then create the
> following defined names* using the Name Manager (formulas tab in Excel
> 2007+). I recommend *making them Sheet-level names* rather than the
> default Workbook-level.
>
> 1. *Name*
>
> =$A2
>
> 2. *_Name.Terminated*
>
> =Name&","
>
> 3. *_Name.ColumnIdx*
>
>
> =TRANSPOSE(ROW(INDIRECT("1:"&LEN(_Name.Terminated)-LEN(SUBSTITUTE(_Name.Terminated,",","")
>
> 4. *_Name.StartPositions*
>
>
> =IF(Name.ColumnIdx>1,FIND(CHAR(1),SUBSTITUTE(Name,",",CHAR(1),_Name.ColumnIdx-1)))+1
>
> 5. *_Name.StopPositions*
>
> =FIND(CHAR(1),SUBSTITUTE(_Name.Terminated,",",CHAR(1),_Name.ColumnIdx))-1
>
> 6. *Name.Columns*
>
> =MID(Name,_Name.StartPositions,_Name.StopPositions-_Name.StartPositions+1)
>
>
>
> *The purpose of using the defined names is to simplify the formula by
> breaking it into steps. Insofar as the steps are referred to more than
> once in the formula, it should make the formula faster to evaluate too. *
> *Name.Columns** is the culmination of our calculation and results in an
> array containing each comma-separated value from column A, divided into
> separate columns.*
>
>
>
> ·To display the column-separated values on your spreadsheet, *enter
> the following formula in **B2*:
>
> =Name.Columns
>
>
>
> ·Then *highlight from **B2** to the furthest column on row 2
> needed* to display the maximum number of values ever expected. For a
> maximum of 3 values, highlight B2:D2, or for maximum of 10, B2:K2, etc.
>
> ·Then hit *F2* (edit cell) and *Ctrl-Shift-Enter* (confirm array
> formula). This confirms a multi-cell array formula over the selected cells.
>
> ·Copy the array-entered range from row 2 (e.g. B2:D2) to every
> other row in your table.
>
>
>
> Hope this is of interest,
>
> Asa
>
>
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Mangesh Vimay
> *Sent:* Monday, September 10, 2012 4:04 AM
> *To:* excel-...@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need help - To divide the string into three
> parts
>
>
>
> Hi Friends,
>
>
>
> I need your help to divide the string into three parts.
>
> The description and sample is given below :
>
> [image: Inline image 1]
>
> Waiting for your response.
>
>
>
> Thanks.
>
>
>
> --
> With regards,
>
>
>
> *MaNgEsH*
>
>
>
> --
> 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 Goog
Re: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks
As Paul said, there is a better way. Provide a file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: SridharBL Sent: Wednesday, September 12, 2012 4:13 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks Hi Experts, I am working as a analyst and I do publish the review files to Leaders. I have one Base excel file, which has two sheets "Basesheet" & "Pipeline" sheets. I have to publish 15 review reports to different leaders. So I should be manually copy "Basesheet" & "Pipeline" to all the 15 excel files. Later I filter and delete unwanted data's in these sheets in those 15 files. So, is there a VBA code to copy the "Basesheet" & "Pipeline" to all the 15 files of different names. -- 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. -- 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.
Re: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks
There isn't a pre-existing code to do ANYTHING. It has to be "built" or "assembled" from VBA tools. What I would do: -Open "master" file. -Start recording a macro (stored in Master file) -Open one of the 15 report files -Copy the sheets to the report file. -Save the file and exit the REPORT file. -Stop Recording. Next: Create a list of the 15 report files in a sheet. (you COULD list them in the VBA, but it means a programming change to add/remove file names) Edit your recorded macro to read loop through the list and repeat the recorded actions for each file in the list. An additional alternative is: You mentioned that you filter/delete unwanted data in each of the 15 files. Why not write the macro to filter the data and only copy the necessary data to the files? Sure would save you some time! If you need help with any of this, let us know. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: SridharBL To: excel-macros@googlegroups.com Sent: Wed, September 12, 2012 5:14:02 AM Subject: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks Hi Experts, I am working as a analyst and I do publish the review files to Leaders. I have one Base excel file, which has two sheets "Basesheet" & "Pipeline" sheets. I have to publish 15 review reports to different leaders. So I should be manually copy "Basesheet" & "Pipeline" to all the 15 excel files. Later I filter and delete unwanted data's in these sheets in those 15 files. So, is there a VBA code to copy the "Basesheet" & "Pipeline" to all the 15 files of different names. -- 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. -- 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.
Re: $$Excel-Macros$$ Excel sheet wise restrictions required for end users
Try this attachment On Wed, Sep 12, 2012 at 2:28 PM, Pravin Gunjal wrote: > Dear Masters, > > > > In the attached file there are six working sheets in it. > > The concerned person will send a mail of this file to his down level for > their working/use. > > > > *Sheet 1 *is made for the master (which can be seen to all end users). > While others - *sheet 2 to* *sheet 7 (i.e. ASM to SO5)* are created for > individual details. > > I have used a hyperlink to go to the sub sheets. > > > > *From ASM to SO5 working sheets : *the end users are individuals and one > should not see the others data (it should be password protected or any > other restriction may be given). > > > > *For an example :* If I am a SO4 user then when I click on SO4 button in > the sheet1 before following the link the system should ask a password to > open the SO4 sheet. Otherwise it can be restricted for use. > > > > Please help me out on this issue. If you require any other information > from me please write to me. Thanks a lot ! > > > > *With regards,** > **Pravin Gunjal* > > > > -- > 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. > > > -- Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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. SO_wise_data.xlsm Description: Binary data
$$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks
Hi Experts, I am working as a analyst and I do publish the review files to Leaders. I have one Base excel file, which has two sheets "Basesheet" & "Pipeline" sheets. I have to publish 15 review reports to different leaders. So I should be manually copy "Basesheet" & "Pipeline" to all the 15 excel files. Later I filter and delete unwanted data's in these sheets in those 15 files. So, is there a VBA code to copy the "Basesheet" & "Pipeline" to all the 15 files of different names. -- 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$$ Excel sheet wise restrictions required for end users
Dear Masters, In the attached file there are six working sheets in it. The concerned person will send a mail of this file to his down level for their working/use. *Sheet 1 *is made for the master (which can be seen to all end users). While others - *sheet 2 to* *sheet 7 (i.e. ASM to SO5)* are created for individual details. I have used a hyperlink to go to the sub sheets. *From ASM to SO5 working sheets : *the end users are individuals and one should not see the others data (it should be password protected or any other restriction may be given). *For an example :* If I am a SO4 user then when I click on SO4 button in the sheet1 before following the link the system should ask a password to open the SO4 sheet. Otherwise it can be restricted for use. Please help me out on this issue. If you require any other information from me please write to me. Thanks a lot ! *With regards,** **Pravin Gunjal* -- 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. SO wise data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
