Thank you all for your help.
The most current spreadsheet is attached: 2024.10.02 Supplies List
A few questions:
On the Grocery-Supplies Log tab:
• So, I did convert the range to a table
• I sorted a column and now my banded rows are not consistent. How do I set up the table so I ensure that the banded rows stay consistent after sorting any column?
• My drop-down in column D is not extending when I make a new entry. It's picking up the “StoresRestaurants” named range. Not sure how to fix this.
On the Grocery Report tab
My dates will not sort in properly.
Quote:
I added the date entry (9/2/24), but not sure what I did wrong. It's not in ascending date order on Original Grocery List tab and I inserted rows above 9/9/24.
Somehow this has been corrected. Now sure how.
Quote:
Originally Posted by p45cal
You could set the print region manually.
Or you can define a dynamic named range, and set it as print region.
Thank you, I have to make this very simple to use since the user that will be doing the data entry, it not very skilled with Excel.
Why add at the top? Add to the bottom then sort. No need to insert.
Thank you! I agree that this is the best way.
You could set the print region manually. Select what you want to print, go to the Page Layout tab of the ribbon and click the Print Area icon and choose Set Print Area. Then print.
Alternatively, select the area you want to print, go straight to the Print Dialogue and choose Print Selection:
Thank you, this may be too complicated for the user.
Any help would be greatly appreciated.
Thank you,
Karen
Last edited by Karen615; 10-03-2024 at 06:56 AM.
|