Home > Software engineering >  Consult, how to realize the conditions across the workbook is a classified summary?
Consult, how to realize the conditions across the workbook is a classified summary?

Time:04-23

There are two workbook: the current workbook and raw data. XLSX workbook, need to "the original data. XLSX" classified "E" column in the workbook summary,

First step, using vlookup to "the original data. XLSX" classified "A" column, classification standard in the current workbook sheep3 BCD columns, formula is as follows
=VLOOKUP ([the raw data. XLSX] Sheet1! $A2, Sheet3! B: D, and 3, FALSE)
Classification results that the formula in the current worksheet column B,
- this step right a
The second step, for all belong to the current working table E2 (note: this is a category name) of the book "the raw data. XLSX" classified "E" column of the summary, the following formula
B=SUMIF ($: $B, $E2, [the raw data. XLSX] Sheet1! E: E)
Data error of summary,

Can you tell me how to solve?

CodePudding user response:

Didn't understand, the first formula can only work on this form, that is outside the chain table data can be extracted, but the "style" can not be changed, and may I say no, but I think it should be so, in this operation appearance change style summary should be can not, change the idea, inherit the appearance of the data to the return to operation should be ok, just like you said classification standard in this form will not have a problem, but not a standard and appearance, because appearance did not open

CodePudding user response:

Problem has been solved, are classified into time, paste, take one more Spaces,
thank you
  •  Tags:  
  • VBA