getyourbiglobster
New Member
- Joined
- May 5, 2002
- Messages
- 2
hello, i'm new here.
i am trying to ease the pain in taking an existing excel workbook and modifying it so that it can be in the proper format for importing into our database.
an image of what i'm trying to achieve is here--> http://www.onertia.com/xl.gif
the top workbook in the image is the original file, and i need to strip it down to the lower yellow shaded file format. doing it by hand is a major pain.
i assume that this can either be done by linking, or by some macro or function, but i have no clue where to begin.
any ideas?
thanks for your help.
i am trying to ease the pain in taking an existing excel workbook and modifying it so that it can be in the proper format for importing into our database.
an image of what i'm trying to achieve is here--> http://www.onertia.com/xl.gif
the top workbook in the image is the original file, and i need to strip it down to the lower yellow shaded file format. doing it by hand is a major pain.
i assume that this can either be done by linking, or by some macro or function, but i have no clue where to begin.
any ideas?
thanks for your help.