I have a master file of data in Excel, I want to then for each row of data pate and transpose that row into a new column in a template. The file will be saved using two cell's info and saved to a location. How can I create an automated process for this?
Can anybody please help me with this issue or am I posting in the wrong area
Do you have a sample file that you can upload?
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
So below please see the files.
The CB data file is where I get the information.
Manually I copy from the "Reason" to "No. of Logins" row by row. I'll then transpose them to the "Sample Request CB Dispute", the letter will need to be included, with the correct reason code and description. Each of these files will need to be saved as the "reason code"_"ARN".xls.
I hope this is clearer and any help is greatly appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks