copy/paste not working

**jw01** · 12-20-2010, 12:22 AM

hello

Please Login or Register  to view this content.

it copies to "ed-win" worksheet, but comes blank? any ideas

also, can someone show me how i can make the range ("B52:X52,B74:U74") be copy pasted to all worksheets? thx you

**johnjohns** · 12-20-2010, 01:02 AM

one of the solutions

Please Login or Register  to view this content.

Please Login or Register  to view this content.

rgds

johnjohns

**jw01** · 12-20-2010, 01:39 AM

thx you johnjohn, the second macro worked flawlessly, really appreciate it!

one last thing, would it possible to do the copy/paste but also, have the city name replaced in the formula?

i.e. when the cells are pasted onto worksheet "ed-win", is it possible for the formula or path in the file to alter itself to "ed-win"..i.e. use the tab name or worksheet name and make the change? thx you.

**johnjohns** · 12-20-2010, 01:55 AM

Do you mean you need a formula link to the main sheet, from all the other sheets? Sorry, I did not get you fully. Can you please post a sample w.book?

rgds

johnjohns