Dropping data into Label

questionforyou

New Member
Joined
Mar 10, 2011
Messages
8
I have a workbook with numerous sheets, few sheets have data in standard rows and columns, one sheet has a label/tag setup such as :
Date:___________
Name:__________
Style:__________
Number:________

Is there anyway to highlight a row of data from another sheet and drop that information into the correct spots in label without doing so by individual cell. Not high amounts of information, macro shouldn't be needed. If I try paste special transpose, says can't change part of merged cell, and thats a rather long process which is pretty inaccurate for what I'm looking for,
Thanks for any help!
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

questionforyou

New Member
Joined
Mar 10, 2011
Messages
8
Maybe any idea to drag data to a label like this? Or change label format to support this idea, moving five or six cells at a time into list?

Thanks
 

Ruddles

Well-known Member
Joined
Aug 24, 2010
Messages
5,785
Perhaps get rid of the merged cells? Why do you need them?

Which version of Excel are you using?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,753
Messages
5,524,654
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top