add multiple entries to contents of worksheet

Jul 28, 2006 2 Replies

HI all,



is there a quicker way to add multiple entries to the contents of a worksheet. I need to add all suppliers to a 206 worksheet for tax change reasons.



Thanks in advance.


Assuming the tax has changed for those supplier entries, right-click on the Contents tab and select Recently Changed. The default will be today's changes.

This trick works for most worksheets. If you want to send down various table updates on a daily basis, select the manual filter option for the worksheet, then right-click on Contents tab to add all recently changed entries to that worksheet. Click Approve and you are done.

Greg Digital Retail Solutions

formatting link

Hi Greg,

Thanks, nice trick. unfortunately it didn't achive the desired result. I updated taxrate in supplierlist yesterday, where, for some reason over 1000 items had incorrect and unusual values.

Is a 206 the correct worksheet to use here.

Thanks.

John.

"Greg [DRS]" wrote:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required