Offset doesn't work in closed workbook. You'll have to use INDIRECT. Give us the full file path and we'll give you a formula but bear in mind that this formula will really slow down your file if you have to many of them.
Offset doesn't work in closed workbook. You'll have to use INDIRECT. Give us the full file path and we'll give you a formula but bear in mind that this formula will really slow down your file if you have to many of them.
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks