Re: $$Excel-Macros$$ Need Help

2010-05-26 Thread Bill Q
Thanks for the effort Saggi. It is appreciated. Unfortunatly, it seems that I am guilty of not being specific enough.Here is what I need step by step: 1. We start on this URL : http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1 2. This page defaults to record 1 through 50. 3.

Re: $$Excel-Macros$$ Help breaking out data on single worksheet to multiple worksheets

2010-05-26 Thread Iain Marrs
Paul, Someone at work was able to create the excel add in we needed for this. Thank you for offering your assistance. On Mon, May 24, 2010 at 4:50 AM, Paul Schreiner wrote: > so... you're wanting the data copied to new WORKBOOKS not sheets (as you > said in your first message) > makes sense. >

$$Excel-Macros$$ SendTo

2010-05-26 Thread PWS
I have a workbook which I have written code which will not allow the user to save the workbook unless they have provided specific pieces of information. I had intended to not allow users to Email the worbook without the specific information being present. Thought process was if they cannot save i

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-26 Thread Paul Schreiner
One of the most difficult things to do is to guess the level of expertise of the person asking the question. Sometimes, by observing improper use of terms, we can get an idea. But if the person describes the question in an intelligent manner, then we have to make some assumptions about even what is

$$Excel-Macros$$ Excel keboard short cuts & Macros

2010-05-26 Thread meena lakshmi
Dear Group Members, I want Excel keboard short cuts & Macros please help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-26 Thread Manas Adhikary
Dear All, I want to Print Page Number "N of M" in Footer by Group-wise (i.e. ID Wise) through Access Database Report Design. Kindly give some guideline or VB Code to do the same. Rgds, Manas. -- -- Some important lin

Re: $$Excel-Macros$$ Need Help

2010-05-26 Thread saggi
Use those code : Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy Destination:=Sheets(1).