Copy merged cells

[Dookie]

Well, here is my problem.
I've got two worksheets. The worksheet T6 provides with information the worksheet T7. (so the formula in the cells in worksheet T7 is like this: ='T6'!A1, ='T6'!A2, etc)

In worksheet T6, Ι merge two cells.
Of course this merge cannot be transferred at T7, so the cell remains blank
(If i merge the cells A1 and A2 at Worksheet T6, the information is transferred at the cell A1 of worksheet T7 and the A2 cell of the T7 remains blank)

At worksheet T7, How can it automatically copy the information from the A1 cell to A2, without loosing the copy from the worksheet T6. (When i merge the cells in worksheet T6, i want the information i write in the merged cells (A1 and A2) to be copied at worksheet T7 at both A1 and A2)

Thank you in advance for your support

 

[Joe4]

Best solution: don't use merged cells!!!
Most MVPs/programmers avoid them like the plague for the issues and limitations with them.

Here is an alternative that usually gives you the same visual effect as merged cells but without the issues: http://www.officearticles.com/excel/merged_cells_in_microsoft_excel.htm

 

[Dookie]

What i want to do, has nothing to do with the appearance.

What i'm looking for is something like this:

A B C
5 Jun car
2 Aug car
0 Jul cars
3 May bike
2 Apr truck
0 Mar car

If C6 is car* (I have to use wildcarts) then count A6 but if A6 is zero (0) then look at A5 (the cell above))
So for the example above the result should be 2.

Thank u

(ps: the informations in the cells, are not inserted manually, but it is copied through a formula.)

 

[Joe4]

If C6 is car* (I have to use wildcarts) then count A6 but if A6 is zero (0) then look at A5 (the cell above))

Perhaps something like this?
=IF(LEFT(C6,3)="car",IF(A6<>0,A6,A5),"")

PS You didn't say what you want to return in the event that C6 does not begin with "car". I have it returning an empty string (""). Adjust accordingly.

 

[Dookie]

Dear Friend, this formula really helped, but there is one more thing.....
All the information in the cells are automatically copied from another workbook, so, into the cells there is already this formula : ='[book11.xls]sheet01'!A1
(Workbook= book11
Worksheet= sheet01
Cell= A1)

How could i possibly get into my cell both of these formulas??? (the one above and the one that you have sent me)


And one more thing......

A B C
5 Jun car
4 Aug car
0 Jul cars
3 May bike
2 Apr truck
0 Mar car

I want the result to return in A column . So after i use the formulas, the result will be like this:
A B C
5 Jun car
4 Aug car
4 Jul cars
3 May bike
2 Apr truck
2 Mar car

So my problem is what kind of formula I have to use in cells A1 to A6.

Thank in advance for your help pal...

 

[Joe4]

All the information in the cells are automatically copied from another workbook, so, into the cells there is already this formula : ='[book11.xls]sheet01'!A1
(Workbook= book11
Worksheet= sheet01
Cell= A1)

I am not quite clear on what you mean. But maybe this will help.
In the formula I provided, A5, A6, and C6 are cell references.
The formula you posted above, ='[book11.xls]sheet01'!A1, is really just another cell reference. So you if you are working off different sheets, you should be able to paste the cell references I have in my formula with the cell reference type that you have listed.

Regarding where you are putting your formulas (whatever columns), you just need to adjust your formula accordingly to look at the correct columns. You might want to keep your original column of data, and just hide it, as your formulas seem to run off of that one.