J
Jolibeanz
I have a master spreadsheet which references multiple user generated
spreadsheets. I need to maintain a master for each month. Is it possible to
do a find and replace in ='[XYZ.xls]Entered Data!$B$4 ? Depending on the
user spreadsheet (whether they record their data vertically or horizontally)
the alpha or numeric character changes each month.
Thanks for any help.
spreadsheets. I need to maintain a master for each month. Is it possible to
do a find and replace in ='[XYZ.xls]Entered Data!$B$4 ? Depending on the
user spreadsheet (whether they record their data vertically or horizontally)
the alpha or numeric character changes each month.
Thanks for any help.