Selective auto text inputting

  • Thread starter Thread starter rcoffey
  • Start date Start date
R

rcoffey

I am building a workbook to track vendor transactions. I have several
vendors that are "regulars" and want to track their transactions
separately, but still record them on the "master" sheet.

My workbook has the master sheet and a worsheet for each of the major
vendors. I put a column for each of the major vendors
The idea being if the next transaction is from Vendor A, I can put an x
in their column and the data from that transaction will be copied to
Vendor A's separate worksheet in the next available line. If none of
the "designator" colums have an x the data would remain only on the
master sheet, indicating a random transaction.

Is this possible? And, if so, can someone help me with this? Thank you
very much.
 
First, I don't think I'd do this.

I'd keep all my data in one worksheet. The I'd apply Data|filter|autofilter to
show/hide any subset of my data.

In fact, I'd dedicate a column to just the Vendor--not a separate column per
vendor. Then I'd type in that vendor's name in that column for that row.

If you like this idea, then you could even use some code at Debra Dalgleish to
either update or refresh those "per vendor" records. (I'd refresh from
scratch--just to make sure my data was in sync as soon as I ran the macro.)

I find that some people will update the "vendors" worksheet--instead of the real
master. Then I'm in real trouble.

Deb's site:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top