Macro which can create multiple files out of one Options
 

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

Macro which can create multiple files out of one Options
 

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.

" wrote:

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

Macro which can create multiple files out of one Options
 

On Apr 27, 4:54 pm, Joel wrote:
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.



" wrote:
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- Hide quoted text -

- Show quoted text -

Hello,

No one ever responded back. I need some help!

Macro which can create multiple files out of one Options
 

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!