in the attatched sheet im looking for the method to replace dave with gary. currently im selecting cells b4,c4 and d4 going to replace and changing dave for gary. what i would like to be able to do is just change cell b4 and for that cell to automaticaly cahnge in the formulas. so if i typed gary in b4, formulas in cells c4 and d4 would automaticaly adjust. please help i cant keep doing find and replace all the timeif anyone can help me out that would be great
thanks in advance
Perhaps this in C4 and then dragged right and down:
Formula:
Please Login or Register to view this content.
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
thanks ron. saved me lots of time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks