B table for fixed format, including the three fields of A table
How A table of information into the B table, according to the number per person to generate A fixed table B
CodePudding user response:
Each one a table, more than 500 worksheet? In this case, may need to look for vba code to do online,If only the three fields of A table data merge to B table, can take "number" for the keyword=vlookup (... Formula to retrieve, but, if A table, "name" in front of the "number", adjust the relations of their order, or have to use=match (first... ) to check the line location, reoccupy=offset (... Take "name"), because=vlookup (... ) in the formula to obtain value only after the keywords,
CodePudding user response:
Each generates a fixed table B-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
No one page a sheet?
Have this kind of demand, VBA to realize it
CodePudding user response:
Vlookup is a good thing, combined with a large amount of data is very convenient