+ Reply to Thread
Results 1 to 2 of 2

Add Data to Table w/o VBA from Input on Another Sheet

  1. #1
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Midwest
    MS-Off Ver
    Excel 365
    Posts
    124

    Add Data to Table w/o VBA from Input on Another Sheet

    Hi All,

    Been a while since I've used the forum and still brushing up on Excel acuity. My current dilemma is trying to automate my workbook as much as possible without VBA so it can be used on a phone. I have a worksheet that collects new information from the user in a readable format. I'd like that new information to be populated into my data table in a new line. Again, no VBA please. It seems as thought the only non-VBA tools at my disposal are drop down lists, but these dont exactly perform as needed for the automation. After the information is added to the table, I'd also like the input worksheet to be reset for future input. Something so simple using VBA, but perhaps impossible without it? Thanks in advance!

    Luke
    Office Dude for Small Trucking Company

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Add Data to Table w/o VBA from Input on Another Sheet

    1st, it is always better to upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    2nd, as far as transferring data to another sheet, that COULD probably be done with formula - you cannot "copy" any data with a formula, it only works on the cell it sits in.
    3rd, any "reset" would need VBA

    Perhaps is you show us what you have, and walk us through what you want, there may be other ways available?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 5
    Last Post: 10-01-2016, 11:55 PM
  2. Get values from input table to add data in output table depending on header
    By SBBmaster09 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2016, 03:25 AM
  3. Replies: 7
    Last Post: 06-21-2015, 02:03 PM
  4. Replies: 2
    Last Post: 08-27-2014, 03:13 PM
  5. Replies: 9
    Last Post: 04-15-2014, 08:12 PM
  6. Transfer single column input data to fixed table in a separate Sheet
    By Prokis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2012, 05:37 AM
  7. Replies: 9
    Last Post: 04-04-2011, 12:03 AM

Tags for this Thread

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