Transpone Excel tables with macro/VBA
 

Dear,

Can someone help me with the following please:
I created an access database and I import data from an excel sheet.
With this excel sheet it is very easy to import into access because it
is a normal table with first row containing fields. Nevertheless it is
difficult for people to write data in it, because they have to repeat
certain info all the time. Therefore, I rearranged the table so it is
easier to use, but now, more difficult to import into access (or
impossible). Can someone help me with a macro (and VBA) to get the data
from one table to the other? I'm afraid it is difficult to understand,
so I wanted to add an example file where it will be clear in one view.
Unfortunately, I don't think we can add files, so please check the url:
'example excel file'
(http://users.pandora.be/oliviernuytten/Transpone.xls) for an
example...
Some info: Rows where value 3 is missing must be deleted while
transponing!
Thank you very much for your help!!!
Kind regards,Olivier Nuytten


--
onuytten
------------------------------------------------------------------------
onuytten's Profile: http://www.excelforum.com/member.php...o&userid=29753
View this thread: http://www.excelforum.com/showthread...hreadid=494689