+ Reply to Thread
Results 1 to 3 of 3

Multiple rows to save with 1 save action

  1. #1
    Registered User
    Join Date
    04-23-2020
    Location
    Calgary, Alberta
    MS-Off Ver
    2016
    Posts
    2

    Multiple rows to save with 1 save action

    Good day all. First post... here it goes.

    I will have 1 form where multiple "Stages" of information will be added.
    Each "Stage" will have a unique number (1,2,3,3a,4,5...) followed by multiple cells of data related to that 'Stage'

    ie: FORM1

    STAGE 1, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
    STAGE 2, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
    STAGE 3, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
    STAGE 3A, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
    STAGE 4, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc


    What I would like to happen on 1 save command is to save all above data to 1 table but in multiple rows based on the "Stage No."

    So the table rows will end up looking like the above (The form itself will not be set up in rows as above).

    The table will only include the headers "Stage No., From, To, Delta, Type, Name, Date"

    Basically it is a...
    If the Stage number is unique from the others enter the data in the next blank row.


    I hope this makes sense....

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,011

    Re: Multiple rows to save with 1 save action

    make an append query(s) to take the data from you input table, to the target table(s).

    if it takes more than 1 query to chop it up correctly, then put all the queries in a macro, then run the macro.

  3. #3
    Registered User
    Join Date
    04-23-2020
    Location
    Calgary, Alberta
    MS-Off Ver
    2016
    Posts
    2

    Re: Multiple rows to save with 1 save action

    Thanks for the reply ranman256...
    The append query I think I can figure out... It is applying a Macro to split it up that I could use an example of or even a link to a tutorial may help.

    Thanks again.

+ 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. [SOLVED] how to declare action to be used in save as filename?
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2017, 06:47 AM
  2. Replies: 1
    Last Post: 04-29-2016, 11:55 AM
  3. Macro for save as action on excel
    By gobi615 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2014, 05:40 AM
  4. Do action Before Save
    By titaniumjack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2010, 03:55 PM
  5. not allow a save action if ANY data is missing
    By matt7102 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2008, 05:18 PM
  6. [SOLVED] Action Pane is disabled when I save the document and reopen.
    By uma in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-10-2006, 08:59 PM
  7. [SOLVED] Undo a save action
    By John in forum Excel General
    Replies: 1
    Last Post: 01-26-2006, 02:30 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