Hello. I have a list of 270 items with related info. I know how to make the
names from the list create and populate the tab names, and then put the names
of the tabs in a specific cell, but I'd like to put a couple of other pieces
of information from the list in there also. How would I tell Excel for
instance to take everything from column C (except the header, although I can
delete that if necessary) and place it in cell C47 on each worksheet? By that
I mean what's in cell C2 on the list to cell C47 on the first worksheet,
what's in cell C3 on the list to cell C47 on the second worksheet, and so on.
I appreciate any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200811/1