[dcnkleingeld]

Hello,
I am new to the forum.

I have a database with translator info that needs updating, so I would like to send each translator the title row, and row with their data. I there any way with help of VBA to save each row according to data in a specific cell?

Many thanks,
Danielle

[CDHarm]

Hi,

When you do a save you save the entire workbook.
Its not row specific.

[Garf13LD]

Pls upload a sample excel file to describe the things you need.

[dcnkleingeld]

Hi,
I currently have a file with translator information. Each row refers to a different translator. I would like to send each translator with their own data, so they can change their line accordingly.

I have found some software from sobolsoft that could possibly save each row, but then I use the column names.


Is there any way to set up an array formula to export row 1 and row 2, row 1 and row 3, row 1 and row 4?

Many thanks

[CDHarm]

Hi,

When you say "Save" each row. Do you mean you want each go to go to a specific sheet?
If so what do you look at to determine which sheet it should go to?

[20_2_Many]

Which version of MS Office are you using? Access Data Collection in 2007 / 2010 may do what you need (easier). Tutorials and Demos available on youtube to check it out.

[Garf13LD]

Originally Posted by dcnkleingeld

Hi,
I currently have a file with translator information. Each row refers to a different translator. I would like to send each translator with their own data, so they can change their line accordingly.

I have found some software from sobolsoft that could possibly save each row, but then I use the column names.


Is there any way to set up an array formula to export row 1 and row 2, row 1 and row 3, row 1 and row 4?

Many thanks

It is possible to separate with macro. Where do you want it to go?