EXCELL 2002 ON WINDOWS XP

  • Thread starter Thread starter J CADENA
  • Start date Start date
J

J CADENA

I need to be able to select several worksheets in file
Do Ctrl+F (to find a record I'm looking for)
Once found, I need to change/enter data for that record
ONLY
PROBLEM
With this version, I noticed that as I add/chg data on a
cell, the program also ENTERS IT in the same cell in all
the selected worksheets.
I Dont want to have to selec/unselect worksheets
everytime I find the record I want to change, just to
prevent data from going into other worksheets.
Help!
Tnx
 
It has always been the case (since Excel97) that if you select multiple
sheets and then type anything into a cell that the same change will occur in
that cell on every sheet. You must have done something different before
because this is not new for XP.
Richard Choate

I need to be able to select several worksheets in file
Do Ctrl+F (to find a record I'm looking for)
Once found, I need to change/enter data for that record
ONLY
PROBLEM
With this version, I noticed that as I add/chg data on a
cell, the program also ENTERS IT in the same cell in all
the selected worksheets.
I Dont want to have to selec/unselect worksheets
everytime I find the record I want to change, just to
prevent data from going into other worksheets.
Help!
Tnx
 
You must log in or register to reply here.

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

macro active sheet 1
Excel VBA 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How do I unselect a cell in Excel? 2
Want to keep 'historical' data using formulas 2
Create an Invoice from a row of data 2
Multiple worksheet Copy Paste Macro 2

Back
Top