Hi, again, Calimari. I don't know what you mean by "even if the data is
different", but you can certainly insert a column into many or all your
spreadsheets at once. You need to group them:
Click on first sheet tab.
Hold shift.
Click on last sheet tab.
Sheet tabs turn white (grouped).
Insert your column; do whatever you want.
It will happen on all worksheets.
DO NOT FORGET TO UNGROUP!! You can right-click to ungroup, or just click on
some other sheet tab.
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"calimari" wrote in
message ...
I have just completed creating and entering data into thousands of
worksheets. Now someone has decided they want to change and add columns
to my worksheets.
Is there any way to have data copied from 1 cell to another in several
worksheets at a time, even if the data is different?
If there isn't...I'm going to have a melt-down right here at work!

--
calimari
------------------------------------------------------------------------
calimari's Profile:
http://www.excelforum.com/member.php...o&userid=24537
View this thread: http://www.excelforum.com/showthread...hreadid=385099