Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Automating a worksheet in Excel 2003
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Dennis Tucker, post: 3861281"] I assume the formula in F30 includes a reference to cell A1. All you would need to do is; 1. First change the relative A1 reference in cell F30 to absolute($A$1). 2. Then copy and paste cell F30 to cells N1....N20. 3. Then edit the formulas in cells N1....N20. Change "$A$1" to "$M$1" and so on to M20. Dennis [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Automating a worksheet in Excel 2003
Top
