How to add input value cells without creating ranges for data consolidation. Marks(4)
Answers
Answer:hiiee dear!!
Explanation: Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily.
The trouble is, working with Data Consolidation can be tricky! Don’t be put off. Data Consolidation is an incredibly useful tool that help you understand and present your data quickly and easily. The screen may look daunting but like all great things, good planning is the key.
This example contains some tips from Edmund, one of our Excel experts, and will help you decide how to organise your data before you start summarising it to get easily understandable results.
hope it helps...
thank you!!