Excel Macro / modify formulas via user input

[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

[Eddie Burdak]

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.

Rgds

Eddie

[fatboy]

Eddie,
Thanks. I didn't think of that.
Marc