Mirroring a spreadhseet

[Zaidee]

I have a workbook which consists of 20 worksheets which contain scores for a competition. I would like to add a new worksheet that could be printed at the end of the day that just shows competitor name and position that they took.

I was looking at a website that spoke about saving the data as a table and then importing it to a new worksheet but I was unable to work out how to save it and then find it to import it.

Any help would be greatly appreciated as there is a lot of data to copy and paste

[dflak]

We will be able to help you out better if we had a sample workbook.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[loginjmor]

Hi -

It's hard to tell what you have to work with based on just your verbal description. Can you upload a small sample file (maybe 3 sheets) with any sensitive information removed? You can upload a file by pushing the Go Advanced button at the lower right corner of the reply window. Scroll down to the hyperlink labelled Manage Attachments. Then use the Browse and Upload buttons to upload your file.