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!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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,786
Perhaps get rid of the merged cells? Why do you need them?

Which version of Excel are you using?
 

Forum statistics

Threads
1,141,224
Messages
5,705,116
Members
421,378
Latest member
CarlosDuran

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top