Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to automate a sheet re-organization
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 he 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet organization | Excel Worksheet Functions | |||
Automate text import wizard in a protected sheet | Excel Discussion (Misc queries) | |||
Spreadsheet Re-organization | Excel Discussion (Misc queries) | |||
How to automate daily interest in a balance sheet? | Excel Discussion (Misc queries) | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions |