only need 2 columns printed

[Husky]

Not even sure which program to use.
What I'm doing is making a grocery shopping list. There isn't a built in
template for this. But I used something similar.

I have several columns, I've prepped it both in access and in Excel. I don't
use office enough to be familiar with even the basics.


columns are
ID-autonumber, item- text, required-number, on hand-number, buy-number plus a
formula to subtract on hand from required, unit cost-currency, discount-number,
tax-number, aisle-text, and total cost-currency + formula buy times unit cost

Obviously with the formulas Excel should be the program of choice. But there's
a couple functions that I can't find a way to accomplish either in excel or
access.

I want to sort the entire list keeping rows intact on the aisle column, shop
from 1st aisle to last ending up at the checkout, excel screws that up by
sorting columns.

And the 2nd being that when I make the shopping printout, it should print
sorted by aisle, and 2nd only need 2 columns on the printout, item and buy.

So I only want to print 2 columns vs the entire list and have to wade thru all
the extras.

 

[IanRoy]

Hi, Husky;

I don't know enough about Access, to describe how to do what you want in
that program. I think you want to create a "Report," if that helps.

In Excel you should have little problem. If row 1 contains all your column
headers and there are no gaps in that row, select any cell in the "aisle"
column and sort. If that row does contain gaps, select the whole range you
want to sort, choose Data> Sort, and the column you want to sort by. Then
hide the columns you don't want printed. Then print.

Regards,
Ian.

 

[Husky]

Great took an entire 2 minutes from firing it up to printing in excel..

Maybe for future reference you can elaborate on gaps. I tried selecting a range
and sorting, but that's all that got sorted. The rest of the sheet was now
messed up.
ie:
row coffee , buy 2, aisle coffee
row candy , buy 3, aisle candy

with everything going across, the buy columns get interchanged while the aisle
column sorts, but it now refers to anything including candy. Making the list
useless after a sort.

As for gaps, I'll assume you mean an empty cell in the middle of a column or
row.

 

[IanRoy]

Hi, Husky;

Maybe for future reference you can elaborate on gaps. I tried selecting a range
and sorting, but that's all that got sorted. The rest of the sheet was now
messed up.

Why did the range you selected not include everything you wanted to sort, as
I suggested: "select the whole range you want to sort?" I assume it did not,
since you seem to be claiming the "rest of the sheet," whatever that is, did
not get sorted. What was the range you selected?

As for gaps, I'll assume you mean an empty cell in the middle of a column or
row.

Yes, by gap I meant an empty cell in the middle of the row, specifically the
header row. If there is such a gap, and you select a single cell instead of a
range, Excel will assume the range you want to sort ends there, at the gap.

Ian.

 

[Beth Melton]

"Gaps" would mean empty columns/row.

When you create an Excel list there are a few rules to follow:
- The list must be a continuous range of data
- Additional information on the worksheet must be separated by an
empty column/row
- When sorting make sure you do *not* have a range selected

If you follow these simple rules then you shouldn't encounter any
difficulty sorting. For additional information look up "Excel list" in
Help. If you use Excel 2003 you'll find new list features have been
added.

Also, and easy way to hide the columns you do not want to print is to
use the Group feature. Select the columns you want to hide and go to
Data/Group and Outline/Group. You'll see a collapse/expand indicator
(+/-) above the column heading. When you want to print hide the
columns by collapsing the branch.

You could also use Custom Views and the Report Manager but I've found
using the Group feature is just as easy - if not easier.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Husky]

I use office 2000. Like I said it gets so little use there's not a lot of need
in learning everything there is to learn about it.

range: I selected the aisle column, hit sort and aisle is what got sorted.
every other column / row remained as is. In effect screwing up aisle for all
the entries.

only by selecting the single cell in the aisle column did the sheet sort
correctly.

Hi, Husky;



Why did the range you selected not include everything you wanted to sort, as
I suggested: "select the whole range you want to sort?" I assume it did not,
since you seem to be claiming the "rest of the sheet," whatever that is, did
not get sorted. What was the range you selected?


Yes, by gap I meant an empty cell in the middle of the row, specifically the
header row. If there is such a gap, and you select a single cell instead of a
range, Excel will assume the range you want to sort ends there, at the gap.

Ian.

So I just need to make sure I don't make gaps. So far not a big problem.