I am working with Excel 2002 and I want to set up the following:
I have two worksheets in the same workbook. Sheet1 will be used to copy in external data. Sheet2 currently contains a small table of formulas. What I want to do is set Sheet1 up so that, once the external data is imported into it, if values in certain cells comply with set criteria then the formula table in Sheet2 will copy across and be placed next to it (thereby allowing the formulas to automatically appear and be used beside each value that complies with the criteria and not beside any cell that doesn't comply).
Also the criteria I want to set is for a 'true' value to be shown for any cell that contains a single letter (any letter) followed by any 8 digit number. If you know how excel would recognise cells like this please let me know.
Thanks in advance!
I have two worksheets in the same workbook. Sheet1 will be used to copy in external data. Sheet2 currently contains a small table of formulas. What I want to do is set Sheet1 up so that, once the external data is imported into it, if values in certain cells comply with set criteria then the formula table in Sheet2 will copy across and be placed next to it (thereby allowing the formulas to automatically appear and be used beside each value that complies with the criteria and not beside any cell that doesn't comply).
Also the criteria I want to set is for a 'true' value to be shown for any cell that contains a single letter (any letter) followed by any 8 digit number. If you know how excel would recognise cells like this please let me know.
Thanks in advance!
Last edited: