EXCEL MERGE AND LINK ISSUE

[Sumesh Nair]

I have a workbook with 2 sheets ( PO register, PO schedule tracker)

In the first sheet, i have around 10 column ( A:J) details like PO no, Supp Name, PI no, Date, Order value, Payment term etc. ( this i use to fill A2 for 1 supplier, A3 for 2nd supplier and so on)

But the 2nd sheet i have a schedule tracker my datas are like ( A:J) first 3 column are same in both sheet only the difference is in the 2nd sheet i will be merging A2 & A3 for PO no, B2&B3 for Supplier Name, C2&C3 for PO No, after than the D2=Committed Date & D3=Actual Date( the column heading will be like ETD, ETA, Clearance , Delivery etc

Now the issue is like i will be filling the first sheet and i need the 2nd sheet must pick the data automatically but the issue is when i do linking i drag the formula in 2nd sheet it is taking the value ( PO NO, SUpp, PI No ) on alternate row ( A2, then A4 because my 2nd sheet having a merge cell. Now i need to change the formula in each column which is really a time consuming process. So can any one help me for solving this issue.

Waiting for immediate reply

Sumesh Nair

 

[Don Guillett]

The first thing is to get rid of merged cells.....
Or, have a macro do the work. send to me dguillett1 @gmail.com
with a COMPETE explanaition and examples.

 

[Saxman]

I have a workbook with 2 sheets ( PO register, PO schedule tracker)

In the first sheet, i have around 10 column ( A:J) details like PO no,
Supp Name, PI no, Date, Order value, Payment term etc. ( this i use to
fill A2 for 1 supplier, A3 for 2nd supplier and so on)

But the 2nd sheet i have a schedule tracker my datas are like ( A:J)
first 3 column are same in both sheet only the difference is in the 2nd
sheet i will be merging A2 & A3 for PO no, B2&B3 for Supplier Name,
C2&C3 for PO No, after than the D2=Committed Date & D3=Actual Date(
the column heading will be like ETD, ETA, Clearance , Delivery etc

Now the issue is like i will be filling the first sheet and i need the
2nd sheet must pick the data automatically but the issue is when i do
linking i drag the formula in 2nd sheet it is taking the value ( PO NO,
SUpp, PI No ) on alternate row ( A2, then A4 because my 2nd sheet having
a merge cell. Now i need to change the formula in each column which is
really a time consuming process. So can any one help me for solving this
issue.

Waiting for immediate reply

Have a look at this. Merging is 7th down.


http://www.youtube.com/user/ActiveDataForExcel?feature=watch