Excel 2000/VB
 

There are many sorting options within Excel. However I'm
trying to create a macro, that when executed will take a
small range of values in a column in one "tab / worksheet"
of a workbook, clearing and moving the contents in a kind
of initialization action. The purpose for this is to
create a year-to-date population section of a saved file
using information from similarly formatted files
worksheet's.

Also, I'm trying to set up a way to sort (from a main
input page) a list of data containing descriptive jobs
followed by columns with categories, departments, spending
etc. I would like to import each line item if a specific
category or department input is met. This data will
then be copied and put into named "tabs / worksheets"
corresponding to what category or department was sorted
for from the main input list.

Thanks

Excel 2000/VB
 

Kathryn

I think your posting lacks enough detail for specific answers. I am
trying to improve my VB skills so if you wish to send me the
spreadsheet I will see if I can help you. email to
d.proutXXXntlworld.com. Change XXX to @ to solve the anti spam
address

On Wed, 1 Oct 2003 12:43:22 -0700, "Kathryn" wrote:

There are many sorting options within Excel. However I'm
trying to create a macro, that when executed will take a
small range of values in a column in one "tab / worksheet"
of a workbook, clearing and moving the contents in a kind
of initialization action. The purpose for this is to
create a year-to-date population section of a saved file
using information from similarly formatted files
worksheet's.

Also, I'm trying to set up a way to sort (from a main
input page) a list of data containing descriptive jobs
followed by columns with categories, departments, spending
etc. I would like to import each line item if a specific
category or department input is met. This data will
then be copied and put into named "tabs / worksheets"
corresponding to what category or department was sorted
for from the main input list.

Thanks

Excel 2000/VB
 

Kathryn

How is the data obtained and do you have a little more information
about the format and layout of the data you shall be working from.

I spent a long time looking for VB solutions to some complex problems,
but I found that going back to basics was far easier and in the long
run a lot more effective.

Depending on how your data is obtained/stored do not over look the
power of Pivot Tables.

If you want you can provide me a sample of the information you are
working with just email it to me student_bum#yahoo.co.uk (just
changed # to @)-anti spam thingy.


GarethG



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/