How to create new workbooks from current workbook and move data [Closed]

Report
Posts
1
Registration date
Thursday May 26, 2016
Status
Member
Last seen
May 26, 2016
-
Hi,
I have the following workbook named "org_file":

file_name data_1 data_2
File_1 r1 s1
File_2 r2 s2
File_3 r3 s3
.
.
.
File_N rN sN

I would like to do 2 things:
1.
Generate N new files with the names: File_1 ... File_N.
the content of the files should be:
File_1:
r1 s1

File_2:
r2 s2
.
.
.
File_N:
rN sN

2.
The cells r1 in the "org_file" should be changed to be a link to the cell r1 in the new file: "File_1"

Thanks for your help
Roni

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!