Results 1 to 7 of 7

Macro to replace line of data within a table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-17-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel for O365
    Posts
    197

    Macro to replace line of data within a table

    Hi all,

    I have a problem where I've created a sizeable table of data that creates short range programs and workflow trackers, but the end user that manipulates the table has limited excel skills and understanding which of course then effects any worksheets/formulas that come off this table.

    I had an idea where I could create a user form that looks up the content of one line in the data table but displays it in a much more user friendly manner. The end user could then type over this to update the contents of the table by pressing a button(macro) that transfers the new content of the user form to appropriate line in the data table. There is a third sheet that mirrors the data table exactly but then is just equal to the cells in the user form - so this would be the one to update the data table with.

    I've attached a sample workbook that I think would better explain it but any help would be greatly appreciated as this is causing a bit of a headache.

    Many thanks,

    Jason
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace data in a table with same data from another table, bringing formatting with it.
    By Strykewulf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2019, 12:55 PM
  2. [SOLVED] Macro to replace line number in a formula (example attached)
    By ricdamiani in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-23-2015, 06:37 AM
  3. Replies: 0
    Last Post: 09-26-2012, 11:26 AM
  4. (macro) Find and Replace Using Reference Table
    By jamesdella in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2012, 03:03 PM
  5. Find/Replace Macro Using Replace Table
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2011, 11:00 AM
  6. Comparing a Table with another data Table to replace with a Code
    By acsishere in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2008, 01:26 PM
  7. Macro to replace shorthand fields with data from another table?
    By khigh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2007, 01:23 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