M
MeowSayTongue
Hello.
I download a spreadsheet workbook often online that is a DVD database.
I need to correct its structure and bring it into 2k7 form factor to
make my use of it practical.
It is located here:
http://www.hometheaterinfo.com/dvdlist.htm
The file link is: http://www.hometheaterinfo.com/download/dvdlist.zip
It is a 12.7 MB file. More unzipped. 2k3 format.
What I need to do is make a small macro that converts it to a 2k7 single
worksheet file, and shift one column to the leftmost position.
I have been manually performing these tasks by manually saving the file
in the 2k7 format, then I cut and paste the column I want shifted in each
of the three worksheets labeled "a-f", "g-o", and "p-z".
The column I move is the ID column to the leftmost position, in all
three worksheets.
After moving the ID column, I then rename "atof" to "DVDs" and then
addendum the other two sections, creating a single, one worksheet flat
file database. I then delete the two original middle and end worksheets.
Are there not a few quick macro functions I could utilize to do this?
Meow
I download a spreadsheet workbook often online that is a DVD database.
I need to correct its structure and bring it into 2k7 form factor to
make my use of it practical.
It is located here:
http://www.hometheaterinfo.com/dvdlist.htm
The file link is: http://www.hometheaterinfo.com/download/dvdlist.zip
It is a 12.7 MB file. More unzipped. 2k3 format.
What I need to do is make a small macro that converts it to a 2k7 single
worksheet file, and shift one column to the leftmost position.
I have been manually performing these tasks by manually saving the file
in the 2k7 format, then I cut and paste the column I want shifted in each
of the three worksheets labeled "a-f", "g-o", and "p-z".
The column I move is the ID column to the leftmost position, in all
three worksheets.
After moving the ID column, I then rename "atof" to "DVDs" and then
addendum the other two sections, creating a single, one worksheet flat
file database. I then delete the two original middle and end worksheets.
Are there not a few quick macro functions I could utilize to do this?
Meow