Replace function!!!!!!
I have 3 worksheets that are linked to a file somewhere on the network
drive. The 3 worksheets contain period name i.e. May which I would like to change everymonth. Currently I highlight the 3 worksheets and use the replace function to change the period every month i.e. from April to May. As this procedure sometimes take too long, Iam thinking of creating a month list on a separate worksheet and thinking that once a month is selected it would authomatically replaces the month in the 3 worksheets. Has anyone got an ideal how this may work using macro or any authomated form? Many thanks in advance. |
Replace function!!!!!!
Hi,
This is how I would do it: 1) make new sheet with a cell containing the current period name 2) on the 1st worksheet overytype the first mention of the period (e.g. May) with "=" and then click on the worksheet and the cell that contains your current period name. 3) copy that formula 4) seach and replace the period name (e.g." MAY") with this formula 5) now you just have to change the cell on the new sheet containing the current period name and all other references will update. "Ola2B" wrote: I have 3 worksheets that are linked to a file somewhere on the network drive. The 3 worksheets contain period name i.e. May which I would like to change everymonth. Currently I highlight the 3 worksheets and use the replace function to change the period every month i.e. from April to May. As this procedure sometimes take too long, Iam thinking of creating a month list on a separate worksheet and thinking that once a month is selected it would authomatically replaces the month in the 3 worksheets. Has anyone got an ideal how this may work using macro or any authomated form? Many thanks in advance. |
All times are GMT +1. The time now is 12:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com