OK,
So, I have a sheet in which I want to manipulate some data. As it stands right now, the A Column is a series of codes (i.e. 001, 002, 003...) and the headers are different states (AL, AK, AZ, AR...), and the intersecting cells contain the correlating value of each code in each state. Now, my task is to rearrange this sheet so that I get a table that looks something like:
AL 001 X
AL 003 Y
AK 003 Z
AZ 001 A
And so on. Can anyone instruct me on how I might accomplish this?
tia!
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks