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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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
 
Upvote 0
Perhaps get rid of the merged cells? Why do you need them?

Which version of Excel are you using?
 
Upvote 0

Forum statistics

Threads
1,218,620
Messages
6,143,518
Members
450,492
Latest member
Rusbus1972

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
Back
Top