#1
|
|||
|
|||
How to change colums to values
Not sure if the title represents the question I am asking but here is the challenge. I have a spreadsheet with has the value "Name" and each month as the column header. In each row it will have the persons name and under each month header it will have their sales amount. I have included an example in this thread.
My goal is to upload this spreadsheet into access with the columns name, month and sales amount so I can use this temporarily to compare with other tables. The first tab shows how the current data is formatted. The second tab show how I would like to possibly store it in access. Prepping data is not my strong point, so feel free to give me other ideas. Once I get it into access, I can write sql all day. Can I get some ideas on how to go from tab1 to tab2? Thanks! CoachJohn |
#2
|
||||
|
||||
There might be—probably is—a clever way to do this with worksheet functions. As I get more used to VBA I tend to go there quicker rather than spend time trying to figure out how to do it with formulae. So let me ask this first: Is this something you want to repeatedly, say once a week, with different data each time? If so, rather than set up clever formulae maybe a VBA macro would serve you better.
And it does have the advantage that I know how I'd go about it . But maybe someone else here will think up a non-VBA solution for you. |
#3
|
|||
|
|||
Hi,
Check this attachment. I cleared the "Needed Sheet" of its data. When you click the button it should transfer the data from the Current sheet to the "Needed" sheet. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to change the font color of cell values | sky474 | Excel | 7 | 03-06-2014 09:15 AM |
Fields/Colums in folders | cilimpuli | Outlook | 1 | 03-10-2013 12:20 PM |
change values based on cell | ubns | Excel | 1 | 05-21-2012 06:28 PM |
Add _ based on a calculated colums | stovaaa | Excel | 4 | 03-09-2012 08:32 AM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |