I have a multi-sheet excel workbook (diff sheet for each day of the month, and a master report sheet). The master report sheet currently consists of links to cells on worksheet '1'.

What I'd like to do is create a macro that takes input from the user via an input prompt and goes through all cells on the master report sheet and modifys the links according to what page the user selects (e.g. 1-31) that they want data from.

I'm a newbie at VBA scripting within Excel.

Any help would be appreciated.
Marc

01-19-2006, 09:02 AM

Eddie Burdak

Quote:

Originally Posted by fatboy

I have a multi-sheet excel workbook (diff sheet for each day of the month, and a master report sheet). The master report sheet currently consists of links to cells on worksheet '1'.

What I'd like to do is create a macro that takes input from the user via an input prompt and goes through all cells on the master report sheet and modifys the links according to what page the user selects (e.g. 1-31) that they want data from.

I'm a newbie at VBA scripting within Excel.

Any help would be appreciated.
Marc

Well what I did to get my self going in VBA was

start the macro recorder
Perform the operation I wanted it doing once.
stop the recorder

Now edit the macro. You will see Excel specific operations but you'll notice how VB it really is.

Give it a whirl. If you know VB you'll pick up VBA realtively quickly - not efficiently but quick enough.