I have some questions

1. Find cells that are between 8000000 and 9000000 range and
replace the cells in a column that are in that range with a different name.
Creating separate files:

Questiona:
A) Which Column?
B) Is 8-9 millillion the value 9not row number).
C) Do the cell need to be compacted? (eliminating rows and columns)?
D) Which column(s) does the data end up in.

2) I need to delete everything that does not equal to a range for example:
"PC". When other rows are deleted I need it to create a new file with a name
of "PC" and so on...

Questions:
A) Are the names Ranges declared in worksheet? (not in VBA)

3) Show quoted text - Hide quoted text
Question:
A) What is quoted Text. Do you mean Text Cells.
B) You can only hide Rows or columns? Instead of hiding, can we change
background color of cells?



Hello,

No one ever responded back. I need some help!