$$Excel-Macros$$ Hi guys I need your help again.
Hi, Can any one tell me how we can link the macro code to hyperlink. I want to navigate the sheet by click the next or previous by using Activesheet.next.select or activesheet.previous.select And I want this two link on each sheet present on my work. Just for your information the sheets are dynamically add as per the logic applied on back end they could be one or 100. Thanks Shariq Sent on my BlackBerry® from Vodafone -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Help in Cross tab
Thanks Dave Thanks for your help.I have not checked the sheet coz I'm not on my laptop but I know your are very good in vba. Thanks Shariq Sent on my BlackBerry® from Vodafone -Original Message- From: Dave Bonallack Sender: excel-macros@googlegroups.com Date: Sun, 22 Aug 2010 15:10:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Hi, I have re-done your sheet using VBA. It will accommodate as many rows as needed on the report sheet, and up to 10,000 rows on the DATA sheet (although this can easily be increased) The button can be moved to any convenient spot on the worksheet. Just right-click, then drag it. Regards - Dave. To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: shariqcoo...@gmail.com Date: Sat, 21 Aug 2010 10:19:33 + Yes Dave..the solution is very good..but I want to do this by clicking the bottom and the data could me any length n the only constant thing is the hours which is not more then 22 but can be less Sent on my BlackBerry® from Vodafone From: Dave Bonallack Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 18:16:12 +0800 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Thanks Andy. You're welcome. Regards - Dave. Date: Sat, 21 Aug 2010 15:33:03 +0530 Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: aind...@gmail.com To: excel-macros@googlegroups.com Hey Dave, This is great!! you never stop amazing me with your simple solutions to complex problems.. Keep it up man!! You are a pillar of our group... Cheers!!! Andy On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack wrote: Hi Shariq I've done this with worksheet functions, not VBA. The original formula is in B3 on the Report sheet. It's then just copied down, then copied across. If you really need it in VBA, it can be done easily enough, but this way updates instantly with any change to the DATA sheet; and some people don't like opening or receiving files with macros. Regards - Dave. > Date: Sat, 21 Aug 2010 13:26:35 +0530 > Subject: $$Excel-Macros$$ Need Help in Cross tab > From: shariqcoo...@gmail.com > To: excel-macros@googlegroups.com > > Hi All, > > I need your help, as I’m unable to solve the problem which I’m going > to explain you guys…….. > Please refer the attached the excel with two tabs “Data” and “Report” > On Data tab I have three columns loaded and Date and hours. Now I need > a macro code to generate a report actually the cross between Date and > Hours(we don’t have duplicate hours in date) and the we have max 22 > hours in a date . if we have particular hours is the Data tab under a > date then we need to flag the value with “Yes” under the fixed > location of that hours in Report Tab. > > I hope you guys understand what I need. I cannot use pivot table. > If you look into the attached excel you will get an idea what I need. > Please help me guys……. > Thanks in advance > > > > Thanks and Reagrd’s > Shariq > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER fo
Re: $$Excel-Macros$$ Re: Need Help in Cross tab
I want to do by using a simple click of button as this the problem is the small part of my complete project and once the report is generated ...I need to do more calculation ..a vba code is required so that a baby can generate the qa report Thanks Shariq Sent on my BlackBerry® from Vodafone -Original Message- From: "Kishan Reddy, K" Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 02:17:56 To: MS EXCEL AND VBA MACROS Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need Help in Cross tab Hello Shariq, I don't understand why can't you use pivot table. Actually, it is simple with pivot table. Just drag the date to the rows header. drag the hours to the column header. LoadId to the data area. If you get sum on loadId, double click on it, and change it to count. The only difference is you will get 1, instead of Yes. Regards, Kishan Reddy, K On Aug 21, 12:56 pm, shariq khan wrote: > Hi All, > > I need your help, as I’m unable to solve the problem which I’m going > to explain you guys…….. > Please refer the attached the excel with two tabs “Data” and “Report” > On Data tab I have three columns loaded and Date and hours. Now I need > a macro code to generate a report actually the cross between Date and > Hours(we don’t have duplicate hours in date) and the we have max 22 > hours in a date . if we have particular hours is the Data tab under a > date then we need to flag the value with “Yes” under the fixed > location of that hours in Report Tab. > > I hope you guys understand what I need. I cannot use pivot table. > If you look into the attached excel you will get an idea what I need. > Please help me guys……. > Thanks in advance > > Thanks and Reagrd’s > Shariq > > Sample Data.xls > 31KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Help in Cross tab
Yes Dave..the solution is very good..but I want to do this by clicking the bottom and the data could me any length n the only constant thing is the hours which is not more then 22 but can be less Sent on my BlackBerry® from Vodafone -Original Message- From: Dave Bonallack Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 18:16:12 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Thanks Andy. You're welcome. Regards - Dave. Date: Sat, 21 Aug 2010 15:33:03 +0530 Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: aind...@gmail.com To: excel-macros@googlegroups.com Hey Dave, This is great!! you never stop amazing me with your simple solutions to complex problems.. Keep it up man!! You are a pillar of our group... Cheers!!! Andy On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack wrote: Hi Shariq I've done this with worksheet functions, not VBA. The original formula is in B3 on the Report sheet. It's then just copied down, then copied across. If you really need it in VBA, it can be done easily enough, but this way updates instantly with any change to the DATA sheet; and some people don't like opening or receiving files with macros. Regards - Dave. > Date: Sat, 21 Aug 2010 13:26:35 +0530 > Subject: $$Excel-Macros$$ Need Help in Cross tab > From: shariqcoo...@gmail.com > To: excel-macros@googlegroups.com > > Hi All, > > I need your help, as I’m unable to solve the problem which I’m going > to explain you guys…….. > Please refer the attached the excel with two tabs “Data” and “Report” > On Data tab I have three columns loaded and Date and hours. Now I need > a macro code to generate a report actually the cross between Date and > Hours(we don’t have duplicate hours in date) and the we have max 22 > hours in a date . if we have particular hours is the Data tab under a > date then we need to flag the value with “Yes” under the fixed > location of that hours in Report Tab. > > I hope you guys understand what I need. I cannot use pivot table. > If you look into the attached excel you will get an idea what I need. > Please help me guys……. > Thanks in advance > > > > Thanks and Reagrd’s > Shariq > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric
Re: $$Excel-Macros$$ Need Help in Cross tab
Hi Dave, Thanks for your help it is very good solution. But I need a macro code as the problem I shared with the group was the very small part of my vba automation project..actually my mind is not giving me the solution of this problem that is why I shared with you allplease send me the code if you can do is easily... thanks Shariq Sent on my BlackBerry® from Vodafone -Original Message- From: Dave Bonallack Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 17:15:26 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Hi Shariq I've done this with worksheet functions, not VBA. The original formula is in B3 on the Report sheet. It's then just copied down, then copied across. If you really need it in VBA, it can be done easily enough, but this way updates instantly with any change to the DATA sheet; and some people don't like opening or receiving files with macros. Regards - Dave. > Date: Sat, 21 Aug 2010 13:26:35 +0530 > Subject: $$Excel-Macros$$ Need Help in Cross tab > From: shariqcoo...@gmail.com > To: excel-macros@googlegroups.com > > Hi All, > > I need your help, as I’m unable to solve the problem which I’m going > to explain you guys…….. > Please refer the attached the excel with two tabs “Data” and “Report” > On Data tab I have three columns loaded and Date and hours. Now I need > a macro code to generate a report actually the cross between Date and > Hours(we don’t have duplicate hours in date) and the we have max 22 > hours in a date . if we have particular hours is the Data tab under a > date then we need to flag the value with “Yes” under the fixed > location of that hours in Report Tab. > > I hope you guys understand what I need. I cannot use pivot table. > If you look into the attached excel you will get an idea what I need. > Please help me guys……. > Thanks in advance > > > > Thanks and Reagrd’s > Shariq > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe