Macro which can create multiple files out of one

[ZhenyaVirina]

I 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!!

 

[Jean-Guy Marcil]

(e-mail address removed) was telling us:
(e-mail address removed) nous racontait que :

I 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!!

This is a Word group. You should be posting in an Excel group.


--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[ZhenyaVirina]

(e-mail address removed) was telling us:
(e-mail address removed) nous racontait que :










This is a Word group. You should be posting in an Excel group.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site:http://www.word.mvps.org- Hide quoted text -

- Show quoted text -

thanks, i am new to this