+ Reply to Thread
Results 1 to 2 of 2

How to - Move, edit and duplicate selection of cells

  1. #1
    Registered User
    Join Date
    11-24-2015
    Location
    Tallinn, Estonia
    MS-Off Ver
    Office365
    Posts
    1

    How to - Move, edit and duplicate selection of cells

    Hello,

    I am creating sticker label layouts for printing and I need some help.



    1)There are 2 sheets in the document.
    *I would like to learn a formula that can be added to green boxes in "Data" sheet which changes the corresponding data in "Sheet1" sticker layout.

    2)Actual stickers are on A4 format paper and the data in excel document is arranged and sized to fit them.
    *I would also like to know how to move the selection of cells ( with its format, width and height) accross the excel document in A4 paper size limits.
    For example I have a sticker paper where there are already first 10 stickers used and in order to continue I have to command the data to move to the right place.

    *In addition, how the sticker layout can be duplicated?For example, if I need to print 10 stickers.
    Last edited by Martin7R; 11-24-2015 at 10:10 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,243

    Re: How to - Move, edit and duplicate selection of cells

    You might find the (MS Office) WORD "mail merge" a better solution. for this problem.

+ 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. Edit edit links macro to automate sheet selection
    By sds1126 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2015, 12:27 PM
  2. Move cells based on duplicate value of other cell
    By chowmouse21 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-14-2013, 06:58 AM
  3. Formula to move selection three cells to the right in a different sheet
    By lukestkd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2012, 04:05 PM
  4. Move duplicate cells into adjacent columns
    By badgerade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2009, 07:59 AM
  5. Tools-Options-Edit-Move Selection
    By kc27315 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2008, 10:04 AM
  6. Edit selection
    By lckjob in forum Excel General
    Replies: 2
    Last Post: 12-15-2006, 04:54 PM
  7. duplicate listbox selection to range of cells?
    By lozc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2006, 09:02 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