Closed Thread
Results 1 to 2 of 2

Help required from a relative novice and newby

  1. #1
    Registered User
    Join Date
    01-18-2017
    Location
    coventry
    MS-Off Ver
    365 pro plus
    Posts
    3

    Question Help required from a relative novice and newby

    Apologies if this post is in the wrong forum channel but I think this is where it should reside. I need to understand if it is possible to generate a document from an individual line of data in a worksheet. I would need to be able to create the document format initially and have the line data map into specific fields to create the final document. I would need to be able to create 1 copy per line of data.

    I have a master worksheet onto which we enter jobs / pieces of work.

    Each line represents 1 individual job and the data stretches up to around 20 columns of data, including dates, customer codes, customer references, delivery dates, addresses, job information and costs.

    For example :

    03/01/2017, AE009876, 24/10/2016, DHL, 4435609897B1, 4435678832C2, 03/01/2017, St Pauls Cathedral, London, 4xMercedes, £1250. [radiobutton]
    04/01/2017, AG009234, 20/12/2016, TARGET, 467635867Y1, 47468376825K1, 04/01/2017, Etihad Stadium, Manchester, 3xBMW I8, £985. [radiobutton]

    Ideally I would like to be able to highlight a specific line or lines using something like a radio button at the end of the specific line and then have a button to press/select to print either the single or many highlighted work documents.

    Does anyone feel they might have an answer for this please.

    Much appreciated and please bear with me I am not overly technical.

    Many Thanks.

    T

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Help required from a relative novice and newby

    Duplicate thread closed.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Newby
    By MartinJohn in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-18-2016, 08:00 PM
  2. Replies: 13
    Last Post: 10-26-2014, 08:20 PM
  3. Newby
    By kenbird in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-18-2014, 07:50 PM
  4. Newby
    By CFritz7 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-27-2013, 10:28 AM
  5. Another Newby!
    By sshot1 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-05-2012, 02:19 PM
  6. Date since and relative cell formula required...
    By Scrumpydoo84 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-29-2012, 01:33 PM
  7. newby
    By Phil McDowell in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-02-2012, 12:12 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