E
Emma
Hi. Am consolidating data from several workbooks into
one. Worksheets are set up with a header at top of each
column. First cell of each row is a date, with pertinent
data entered in columns. For example, A2 shows 4/1/04, B2
has customer name, C2 has an X, D2 is empty, E2 has an X,
and so on. Consolidation is working fine except for one
workbook which is set up the same as the others. When the
data is consolidated, instead of putting the data from row
2 of the source into one row of the consolidated, it is
combining data from two rows, such as A2, B2, C3. Only
happening with this one source workbook. What should I
look for that might be causing the problem? Thanks for
any suggestions.
one. Worksheets are set up with a header at top of each
column. First cell of each row is a date, with pertinent
data entered in columns. For example, A2 shows 4/1/04, B2
has customer name, C2 has an X, D2 is empty, E2 has an X,
and so on. Consolidation is working fine except for one
workbook which is set up the same as the others. When the
data is consolidated, instead of putting the data from row
2 of the source into one row of the consolidated, it is
combining data from two rows, such as A2, B2, C3. Only
happening with this one source workbook. What should I
look for that might be causing the problem? Thanks for
any suggestions.