$$Excel-Macros$$ Hi guys I need your help again.

2010-08-23 Thread shariqcool4u
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

Re: $$Excel-Macros$$ Need Help in Cross tab

2010-08-22 Thread shariqcool4u
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 davebonall...@hotmail.com Sender: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need Help in Cross tab

2010-08-21 Thread shariqcool4u
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

Re: $$Excel-Macros$$ Need Help in Cross tab

2010-08-21 Thread shariqcool4u
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

Re: $$Excel-Macros$$ Re: Need Help in Cross tab

2010-08-21 Thread shariqcool4u
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