formula

[EAG]

I'm tring to get sheet one to post on sheet two under the months of the year.
when i change January to Februay on sheet 1 the text for January disapears
on sheet two!
is there a formula I can use to fix this?

 

[Satti Charvak]

Could you be more elaborate....or if possible provide us with some sample
data. Your mail is basically not clear.

 

[sanju5064]

I'm tring to get sheet one to post on sheet two under the months of the year.
when i change January to Februay on sheet 1 the text for January disapears
on sheet two!
is there a formula I can use to fix this?

you can use copy the data and then in pastespecial select past link.

 

[EAG]

Im tracking the amount of tickets submited for each month of the year.
i used =sheet1b2 (B2 would be the month of year) on sheet 2 to post data
from sheet one.
its shows the data entered for the month of January but it i change B2 to
March or any other month all data for January disapears.