1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Save each row in Excel

Discussion in 'Business Applications' started by dcnkleingeld, Aug 16, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. dcnkleingeld

    dcnkleingeld Thread Starter

    Joined:
    Aug 16, 2012
    Messages:
    2
    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
     
  2. CDHarm

    CDHarm

    Joined:
    May 26, 2011
    Messages:
    251
    Hi,

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

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Pls upload a sample excel file to describe the things you need.
     
  4. dcnkleingeld

    dcnkleingeld Thread Starter

    Joined:
    Aug 16, 2012
    Messages:
    2
    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
     

    Attached Files:

  5. CDHarm

    CDHarm

    Joined:
    May 26, 2011
    Messages:
    251
    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?
     
  6. 20_2_Many

    20_2_Many

    Joined:
    Jun 29, 2012
    Messages:
    518
    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.
     
  7. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    It is possible to separate with macro. Where do you want it to go?
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1065351