Hi all: I am using a spreadsheet with the following formula:
It works brilliantly, except for one issue: If I need to insert or remove a row in the CJNH 2011 spreadsheet, which I often have to do, the formula does not change. Is there a way (perhaps using match) to alert the formula so that the formulas reflect changes made to rows? Thanks in advance.
Please Login or Register to view this content.
Not sure if this is it...
This is looking for a match in column A of other workbook to find the word "Total" to determine the row number it should look at...Please Login or Register to view this content.
Adjust range and match criteria as necessary
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks