Macro which can create multiple files out of one Options

[ZhenyaVirina]

Macro which can create multiple files out of onI don't have a code
written for this.


I need to build it from scratch.
I know how to do basic macro recording (changing font size and date
etc).

Here is the 1st thing that I need the function to do.


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:


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...


Can someone please help me!!
e Options

 

[Joel]

If you don't get any other response, I can help. Will have some time this
weekend if you need help. Reply to this posting.

 

[ZhenyaVirina]

If you don't get any other response, I can help. Will have some time this
weekend if you need help. Reply to this posting.










- Show quoted text -

Hello,

No one ever responded back. I need some help!

 

[Joel]

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?