My formula is
=IF(INDIRECT("'Section 1'!$F$3") = 0, " ", INDIRECT("'Section 1'!$F$3"))
When I run the macro I want it to read
=IF(INDIRECT("'Section 2'!$F$3") = 0, " ", INDIRECT("'Section 2'!$F$3"))
But I want it to be able to add 1 to any Section that I use that for.
Sorry, forgot to attach the workbook.
The cells in question are in the B column of the Table of Contents
Dutch =ALS(INDIRECT("'Section "&RIJ()-3&"'!F3")=0;"";INDIRECT("'Section "&RIJ()-3&"'!F3"))
I tried to translate the formula:
b4=If(INDIRECT("'Section "&Row()-3&"'!F3")=0,"",INDIRECT("'Section "&Row()-3&"'!F3"))
and drag down
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
That's perfect! Even better than what I was hoping for. Thank you very much!
Thanks for the reply.
Glad i could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks