Hello:
I was wondering if there is a way to use Excel VBA to solve my problem. Here is the problem:

I have an Excel workbook with two different work sheets on it. One is where users enter their data, the other is a worksheet I am using to help export to XML. My problem is, it is pulling all the information where I might only want to sort one portion out of five into the XML file. Is it possible (and if so, how) to use VBA to help me with this.

The way I have it setup right now is the user enters all the information on Sheet1. Sheet2 then pulls the information into the proper columns and properly formatted (so the things which need to be lowercase are formatted lowercase, etc.). I was using an XSD to map the columns, but it is pulling all the information. For example, I want my information broken into units (even though units is not recorded in the XML file). I'd like to be able to have it generate the XML file and contain only information in unit 2 or unit 3.

Does anyone have any ideas which might be of help?

Thanks in advance for any help.

Dear ARHOLLY,

Having read your problem description, I think what you are trying to do is extract only the filtered rows in your worksheet and paste them to the second spreadsheet you use as your XML source.

If this is the case then one option you might like to consider is to copy the visible cells/ rows after you applied the filter. The syntax below will allow you to copy the visible cells, except for the top row which is likely the header row.

ActiveSheet.UsedRange.Offset(1, 0).SpecialCells (xlCellTypeVisible).Copy

If you search msdn under that method's keyword you will find additional resources which may more closely suit your needs. I hope this helps you in your search for a solution.

Regards,

Jake

courtesy of ... http://www.Excel-Expert.co,uk , http://www.MacroExpert.co.uk , http://www.OfficeSoftworks.co.uk , http:///www.OfficeSoftwork.com