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.

Word forms - copying and pasting

Discussion in 'Business Applications' started by greendai, Aug 17, 2012.

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

    greendai Thread Starter

    Joined:
    Jan 9, 2007
    Messages:
    10
    Hi there

    Last year I created an Appraisal form that we use at work for about 500 people. It's a Word protected form with form fields set in a number of seperate tables

    For this year, I need to add a function that allows a user to open up last year's form, copy one table from it and paste the data into a different table in another copy of the same form

    The table with the data in it is 4 columns wide but may have any number of rows in it. Row 2 onwards needs to be copied across

    The table for the data to be pasted into is 6 columns wide and may not have enough rows to accommodate the pasted data so would need some sort of error trapping to pick up that it needs extra rows adding before pasting.

    Data should be pasted into row 2 onwards and should sit within the first 4 columns of the receiving table. The idea is then the user fills in column 5 and 6 adding comments about the data they have pasted in

    If any extra cells are needed to fit the incoming data they should have form fields in columns 5 and 6 too for entering the comments above

    Phew...hope this makes sense

    My experience of this kind of thing is limited to modifying other people's VB code/macros to add some functionality myself. This is a bit beyond me!
     
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/1065456