Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm keeping track of an auction. I have a worksheet with 4 columns,
Item Number, Item description, Buyer and Amount = Columns A thru D. What I want to do is sort the list by buyer and then copy just the items from each buyer and paste that buyers items (and related data) to a place in the spreadsheet (the printable receipt area), lets call that starting at cell L6. Then I can print his receipt and then repeat the task for each subsequent buyer. I have it working manually, (I can copy the buyers data to the receipt area and then print the receipt) but it would be nice to automate the process. Any help would be greatly appreciated. Jonco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using macros to categorise a list of customers | Excel Programming | |||
Using VLOOKUP without a sorted list | Excel Programming | |||
Sorted list | Excel Discussion (Misc queries) | |||
how do i set up a list of customers in excell for mail merge | Excel Discussion (Misc queries) | |||
How many different customers in a list? | Excel Worksheet Functions |