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 <davebonall...@hotmail.com> 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 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
