Hi Guys,
I have clients that send me data monthly. The format on each excel sheet is different. I have a template that I have to paste the values in. I was wondering if anybody has an idea about how to have an input box to enter client name and the columns from that client will be copied to the correct column on my template. I am sort of a beginner with Macros and this problem cause a lot of hassle and that is why I would like to automate it.
I would really appreciate any help with this.
Thanks
Is the client name enough to know the relevant columns?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
The client has headers on the column that are different from my template. Each client has something completely different from another client and my template.
You'd have to have a way of associating the headers with the client - perhaps a list?
This is what I was thinking. A list that would lookup the client name and return proper column for the template
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks