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