Home |
Search |
Today's Posts |
#1
|
|||
|
|||
A template for limit what is imported/
Hi all...
I can import a product list from my unix database into Excel; once it is there, I often want to delete many columns, as I have no use for them. What I want to do is make a template or similar that will import (into a new spreadsheet, if necessary) only certain columns. In other words, the original spreadsheet is 30 columns, but I only need to work on 5 or 6; how can I tell the new spreadsheet to just import the columns I need? Thanks in advance! John |
#2
|
|||
|
|||
Why not just copy the worksheet to a new sheet and delete the columns you
don't need? -- Vasant "JohnnyJomp" wrote in message ... Hi all... I can import a product list from my unix database into Excel; once it is there, I often want to delete many columns, as I have no use for them. What I want to do is make a template or similar that will import (into a new spreadsheet, if necessary) only certain columns. In other words, the original spreadsheet is 30 columns, but I only need to work on 5 or 6; how can I tell the new spreadsheet to just import the columns I need? Thanks in advance! John |
#3
|
|||
|
|||
Hi...
That is easy enough to do, and is what I am doing, but as the columns are not continuous (ie. columns B-AA), it takes a while to delete 20odd columns. Just trying to speed up the process. John "Vasant Nanavati" wrote: Why not just copy the worksheet to a new sheet and delete the columns you don't need? -- Vasant "JohnnyJomp" wrote in message ... Hi all... I can import a product list from my unix database into Excel; once it is there, I often want to delete many columns, as I have no use for them. What I want to do is make a template or similar that will import (into a new spreadsheet, if necessary) only certain columns. In other words, the original spreadsheet is 30 columns, but I only need to work on 5 or 6; how can I tell the new spreadsheet to just import the columns I need? Thanks in advance! John |
#4
|
|||
|
|||
If they are always the same columns, a simple macro would delete them.
Sub DeleteUnwantedColumns() Range("B:B,E:E,G:G").Delete End Sub -- Vasant "JohnnyJomp" wrote in message ... Hi... That is easy enough to do, and is what I am doing, but as the columns are not continuous (ie. columns B-AA), it takes a while to delete 20odd columns. Just trying to speed up the process. John "Vasant Nanavati" wrote: Why not just copy the worksheet to a new sheet and delete the columns you don't need? -- Vasant "JohnnyJomp" wrote in message ... Hi all... I can import a product list from my unix database into Excel; once it is there, I often want to delete many columns, as I have no use for them. What I want to do is make a template or similar that will import (into a new spreadsheet, if necessary) only certain columns. In other words, the original spreadsheet is 30 columns, but I only need to work on 5 or 6; how can I tell the new spreadsheet to just import the columns I need? Thanks in advance! John |
#5
|
|||
|
|||
Excellent. I have never written a macro, so may be back for help again.
Thanks for the suggestion! John "Vasant Nanavati" wrote: If they are always the same columns, a simple macro would delete them. Sub DeleteUnwantedColumns() Range("B:B,E:E,G:G").Delete End Sub -- Vasant "JohnnyJomp" wrote in message ... Hi... That is easy enough to do, and is what I am doing, but as the columns are not continuous (ie. columns B-AA), it takes a while to delete 20odd columns. Just trying to speed up the process. John "Vasant Nanavati" wrote: Why not just copy the worksheet to a new sheet and delete the columns you don't need? -- Vasant "JohnnyJomp" wrote in message ... Hi all... I can import a product list from my unix database into Excel; once it is there, I often want to delete many columns, as I have no use for them. What I want to do is make a template or similar that will import (into a new spreadsheet, if necessary) only certain columns. In other words, the original spreadsheet is 30 columns, but I only need to work on 5 or 6; how can I tell the new spreadsheet to just import the columns I need? Thanks in advance! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable macros in template d/l from MS? | New Users to Excel | |||
Template Wizard with Data Tracking | Excel Discussion (Misc queries) | |||
Worksheet template variables | Excel Worksheet Functions | |||
Template Wizard - Add-In | Excel Discussion (Misc queries) | |||
Template Wizard Addin Program | Excel Discussion (Misc queries) |