Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Meghan
 
Posts: n/a
Default VB Scripting/Macro - Filling/Editing Worksheet References

Question:

What VB code will allow me to rewrite just the worksheet reference in a
function/cell reference. For example it says

=January!$AH40

and I would like a macro that would change it to

=February!$AH40

Any suggestions would be greatly appreciated!!! :)

Background:

I have 12 cells in a row that each refer to the same cell location on twelve
different worksheets within the same workbook.

The fill function does not "fill" the worksheet reference. It is too time
consuming to manually input or edit 2016 cells.




  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
you may have a look at the INDIRECT function for this

--
Regards
Frank Kabel
Frankfurt, Germany
"Meghan" schrieb im Newsbeitrag
...
Question:

What VB code will allow me to rewrite just the worksheet reference in a
function/cell reference. For example it says

=January!$AH40

and I would like a macro that would change it to

=February!$AH40

Any suggestions would be greatly appreciated!!! :)

Background:

I have 12 cells in a row that each refer to the same cell location on
twelve
different worksheets within the same workbook.

The fill function does not "fill" the worksheet reference. It is too time
consuming to manually input or edit 2016 cells.






  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

This will change the sheet name when copied down

=INDIRECT("'"&INDEX({"January";"February";"March"; "April";"May";"June";"July";"August";"September";" October";"November";"December"},ROW(1:1))&"'!AH40" )

assuming the 12 sheets are named after the months


Regards,

Peo Sjoblom

"Meghan" wrote:

Question:

What VB code will allow me to rewrite just the worksheet reference in a
function/cell reference. For example it says

=January!$AH40

and I would like a macro that would change it to

=February!$AH40

Any suggestions would be greatly appreciated!!! :)

Background:

I have 12 cells in a row that each refer to the same cell location on twelve
different worksheets within the same workbook.

The fill function does not "fill" the worksheet reference. It is too time
consuming to manually input or edit 2016 cells.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copyright and worksheet protection dow Excel Discussion (Misc queries) 2 January 3rd 05 04:07 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 09:45 AM
Executing macro for all worksheet from a different worksheet Biti New Users to Excel 3 December 8th 04 11:05 AM
Linking items GREATER THAN O on another worksheet in the same Work Eddie Shapiro Excel Discussion (Misc queries) 4 December 1st 04 03:55 PM
Worksheet name and Backward compatibility Rich Excel Discussion (Misc queries) 3 November 30th 04 07:10 PM


All times are GMT +1. The time now is 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"