Populate Master Sheet from another sheet [Closed]

Ask a question Same - Last answered on Oct 16, 2016 at 05:48 AM by Ambucias

I want to create a simple entry sheet/report master sheet where records would would be typed into a single row (entry sheet) and the data will populate top cells in the master sheet. With the latest entry automatically populating top row and the last one drops below it on the master sheet?

For example
Entry Sheet Report Sheet
A1 B1 C1 A1 B1 C1
Give 567 ok Give 567 ok

Next entry

Entry Sheet Report Sheet
A1 B1 C1 A1 B1 C1
2 I think 2 I think
Give 567 ok

And so on?

plus moins

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request from CCM forum users to show mutual respect. Therefore, when asking assistance, please be courteous, as for elsewhere in similar circumstances in every day society when asking for something. (Usually, how would someone ask for help? i.e. please, thank you, appreciate, grateful, etc.)

Being courteous will also increase your chances of getting the help you need.

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!