Saving different excel files into different file folders by default

[Khanzaki]

Hi ,
I work with excel .And I have created invoice templates with different customer names on It.Like i hav 3 customers A,B,and C. i.e. i have 3 templates to work .Whenever i enter data into it and create invoice i save a copy of them in respective folders A , B, and C i.e.I have 3 folders to store created invoice .
Now what I want is a macro that would save template A into folder A whenever i enter Data in template A because its a pain to browse through all folders to save a customers file in its Folder each time.
... I hope I am clear with my question .. Responses are deeply appreciated .
Thanks !!!!

[dogberry]

Hi

You can record your own macro for that just record a seperate macro for each folder and choose save as I would use ctrl shift a for folder a ctrl shift b for folder b etc. OK you have to do it three times but after that its just the shortcut keys and it will save to the correct folder.

Chris

[Khanzaki]

I am not getting it Thanks for ur reply dude but being more precise would be good coz i am just a beginner

Thanks