Share via

Extract Data from Form to Excel Spreadsheet

Anonymous
2020-07-17T13:38:30+00:00

I am trying to help a friend who runs a small business. He has several 1000 bills of sale (Excel Form) from which he would like to extract the data to a single spreadsheet - with each row in the spreadsheet representing all the data from a single form. Is this possible and how would he go about it?

I'm attaching an image of a sample form in case that would help understand his problem.

TIA

Roger

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-07-17T13:47:19+00:00

    Hi ROGERBANNISTER!

    I am Jun an Independent Advisor. Thank for posting in our community.

    Please follow the steps on this link on how to consolidate data from multiple sheets into one.

    https://support.microsoft.com/en-us/office/comb...

    If you have any other questions please feel free to ask. Hope this helps and stay safe.

    -Jun

    0 comments