Golf Hdcp

[ajbojey]

Hello everybody,
I have just joined this board and already have a question.
I have been handed down an excel program used for golf handicapping and I’m trying to improve it.
The entry on it is 10 last scores entered in 10 consecutive cells in a row. Now when a new score is entered in the first cell, the score in the last cell has to fall off. Well it is not doing this, you have to knock the last cell score off manually then move all the other scores over to make room for the entry in the first cell. Does anybody know how to make this work automatically?

Alex Bojey

 

[plettieri]

I am sure a simple macro will do this.....you can actually record this youself by trying it manually first to see the routine that you want to use, Then turn on the "Macro Record" on by.... Tools | macro | record new macro.Then do your procedure.... When you are finished turn "macro record" off.

Then run your macro each time you want to make a change.

Does this help..

pll

 

[plettieri]

Hello ajbojey:

I received yr PM and request to expand the macro to a large range. It probably is in the best interest to reply to this board (to the same thread if the same issue) to give all members the opportunity to learn and contribute. With so many observing you will probably get several excellent answers ....This forum has a lot of high caliber members who are supportive and responsive to all the inquiries.

I will post you message here for replies....


"The macro works very nice on the first row, how do I make it common to 200 rows? Do I have to make a macro for all the rows?
Alex"


My reply:

Sure, make the macro for all the rows you want to include. Same process as noted above, but just a larger range.

Hope this helps
good luck

pll



Good luck

 

[ajbojey]

Here is the macro that I am trying to expand to 200 rows, each row has to work independent of each other with the same macro.
What I want to do is to be able to select any cell in E columb from which to run this macro. How do I redefine the Range command to accept just the active cell that I am in?


Range("E2:M2").Select
Selection.Copy
Range("D2").Select
ActiveSheet.Paste

Alex

 

[plettieri]

Try searching on "active cell" within subject and a lot of options are available....try this one which asks basically the same question...

http://216.92.17.166/board/viewtopic.php?topic=4073&forum=2


hope this helps
pll
This message was edited by plettieri on 2002-10-17 21:09

 

[plettieri]

You were able to obtain the info needed? If not, ask the question again at the end of this post and maybe the code writers could answer this for you.

pll

 

[just_jon]

ajbojay -

I've got a file that works on a last-three score basis -- no macro required -- that you should be able to modify for your use. If you'd like me to send it to you let me know how; files cannot be attached thru this board.

Fairways and greens,
just_jon

 

[ajbojey]

No I have not solved the problem yet.
I need some instructions on how to program an ActiveCell.
Alex

 

[ajbojey]

Reply to " just_jon "
Yes you can send it to me at ajbojey@shaw.ca
Thanks
Alex

 

[ajbojey]

Thanks everybody,
I will close this subject and start a new one with a different name as I have not solved the problem.
Alex