Automate Data to Text sequence

[longbow007]

Hello, could someone please help me use Excel 2003 to automate the following sequence of events that I currently do manually?

AutoFilter to filter the City in column B
AutoFilter to filter the Rotation in column X
AutoFilter to filter the Positional Status in column Y
Hide columns B:W

Use the computer mouse to select a range of that includes columns A, and X to AR (inclusive).

Copy 'n' paste this selected range to worksheet: Data to Text at cell A1

Insert a new column by selecting column A and right-clicking on the column and selecting Insert

Populating the new column A starting at cell A1 with number 1 and autofilling down to the last record (1, 2, 3, 4, 5, etc...)

Delete the folowing columns: C, D, E, G, J, L, M, N, P, Q R, S, T and V

Copy 'n' paste the all the remaining data to a new documnet in MS Word 2003

Select the entire table in MS Word

From the MS Word file menu - Select Table - Convert Table to Text

In the Convert to Table to Text pop-up window - select Other radio button and type in a forward-slash "/" in the input box adjacent to the radio button (without the quotes).

Click OK



Example:

AutoFilter the City: Sao Paulo
AutoFilter the Rotation: Second
AutoFilter the Positional Status: Vacant
Hide columns B:W

Select the range A6:AR12

Copy 'n' paste this range to worksheet: Data to Text at cell A1

Insert a new column by selecting column A and right-clicking on the column and selecting Insert

Populating the new column A starting at cell A1 with numbers 1 and autofilling down to the last record (1, 2, 3, 4, 5...)

Delete the following columns: C, D, E, G, J, L, M, N, P, Q R, S, T and V

Copy 'n' paste the all the remaining data to a new document in MS Word 2003

Select the entire table in MS Word

From the MS Word file menu - Select Table - Convert Table to Text

In the Convert to Table to Text pop-up window - select Other radio button and type in a forward-slash "/" in the input box adjacent to the radio button (without the quotes).

Click OK



I need the macro to start when the user has selected the range of data they wish to copy 'n' paste. The macro will end after they click OK in the Convert to Table to Text pop-up window in MS Word.



Any assistance would be greatly appreciated,

Kind regards

Chris