Hi,
I have file where in sheet "edit details", I have list of sheet name, value to be replaced and replacement value.
need vba to to find sheet name, find the value under column "text to be replaced" and replace the particular value with value metnioned under column "replacement value"
for example, in sheet2, find value "Row Labels" and replace with value "Name".
Please note my edit details table rows will increase and decrease time to time.
Bookmarks