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

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

Hi Anne,

Actually, I know how to add new columns into all the work sheets at the
same time. What I don't know how to do is move different numbers located
in the same cell to a different cell, at the same time.

Is this even possible, without having the move change the numbers to be
all the same?

Please let me know if I'm not making myself clear.

Thank you.

-Calimari


--
calimari


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

EWWWW. I don't know about that. Sorry... I highly doubt that will work. Did
you make a copy of your workbook and try it? I really don't think that'll
work.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"calimari" wrote in
message ...

Hi Anne,

Actually, I know how to add new columns into all the work sheets at the
same time. What I don't know how to do is move different numbers located
in the same cell to a different cell, at the same time.

Is this even possible, without having the move change the numbers to be
all the same?

Please let me know if I'm not making myself clear.

Thank you.

-Calimari


--
calimari


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