Run a macro

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,
 
K

KARL DEWEY

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.'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
I need some macro help 11
How to Print a Subreport from a filtered search 1
Run a macro and pause before running second macro 1
Use macro to add new linked record ACC07 8
Important message from Dixons Carphone 1
Run Macro If Cell have "x" value 0
Excel macro to aid visual clarity? 7

Top