+ Reply to Thread
Results 1 to 5 of 5

Need to write to two separate spreadsheets from one form

  1. #1
    Registered User
    Join Date
    05-20-2022
    Location
    San Rafael, CA
    MS-Off Ver
    365
    Posts
    10

    Need to write to two separate spreadsheets from one form

    Can I write to two seperate spreadsheets from one form?
    I am trying to set up a QR-linked form (each unique) for a set of clients. I'm wondering if there is a way to directly output to two seperate sheets from one form, or to set up two forms within a single page to kind of fool the participants into filling both out at the same time?

    Tim

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,303

    Re: Need to write to two separate spreadsheets from one form

    see big yellow banner - upload your workbook - help us to help you - all this is possible.
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

  3. #3
    Registered User
    Join Date
    05-20-2022
    Location
    San Rafael, CA
    MS-Off Ver
    365
    Posts
    10

    Re: Need to write to two separate spreadsheets from one form

    I really wasn't that far yet. I was at the conceptual stage.

    I am eventually going to need to import this data into service that does exactly this... There is a sheet 'case notes' that receives case notes from straight up case note entry
    but also, the comments and ID and such are copied from a different form that writes to a, say, 'orders' sheet... and all those case notes and the vital identifing data from it are written to the 'case notes' sheet as well.

    I want to get my data into something approaching that destination's formats, but am wondering if I can even do it before I start or if this is really something that needs to be done by a program, pulling part of the info
    from a new entry on one sheet and putting the relevant parts in other sheets.

    If one can use a form to simultaneously write data to two seperate sheets seems like a fairly straightforward question to me. If it's more complicated to answer, why is that so, if you have the time to?

    Thanks.

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,303

    Re: Need to write to two separate spreadsheets from one form

    You can write to multiple sheets from one UserForm - just settle on the layout of data in each sheet then upload your workbook and we can guide you from there.

  5. #5
    Registered User
    Join Date
    05-20-2022
    Location
    San Rafael, CA
    MS-Off Ver
    365
    Posts
    10

    Re: Need to write to two separate spreadsheets from one form

    Splendid. I'll be back with that, thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. User form advice. Multi tab, multiple forms or VBA write form
    By Ratso in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2019, 11:16 AM
  2. Opening write protected spreadsheets
    By RGW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2010, 09:51 PM
  3. Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  4. Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  6. Replies: 2
    Last Post: 06-23-2005, 07:05 PM
  7. Replies: 1
    Last Post: 06-23-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1