Run a macro

  • Thread starter Thread starter amm0901
  • Start date Start date
A

amm0901

I have a master list of customers numbers and their payment data. It has
columns a thru z. Column a is the customer #. I would like to be able to run
a macro that will allow me to pull each customers number (and the data
associated with it)and spit it out into a file folder created for that
customer. ANy and all assitance is much appreciated.
Thanks,
 
You need to change your table structure as you have a spreadsheet instead of
a relational database.

You can use a union query to redo the data. Search on 'Normalization.'
 
Back
Top