changing a range of cells throughout a 5 page spreadsheet

  • Thread starter Thread starter Midwest Farmers
  • Start date Start date
M

Midwest Farmers

I have a 5 page worksheet. Each page has approx. 50 customer name headings .
Each customer has a list of dates vertically, Nov-1 through Nov-30, for
example. Information is entered on each day. I need to change Nov to Dec
throughout not only the entire 50 customers on that page but all the other 4
pages as well. How do I do that?
 
If you have entered them as dates like 11/1, 11/2 etc.

Open Find and replace and
replace 11/1 with 12/1 for all matches after choosing workbook in the
'within' drop box

If you have entered as Text then find and replace Nov with Dec.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a sum by matching two cells with the same identifier 1
Match Dates in Two Cells and Ignore subsequent Cells 1
Sum Totaled based on Matching Identical Criteria in Worksheet 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Find criteria based data and display next to a count in another wk 2
How 2 change date in 1 cell/worksheet so it changes in all workshe 2
Summing for every change in a pivot table 1

Back
Top