I need a macro to move data from a list on one worksheet into another
worksheet that looks like a specific format. I need to be able to
select the data in column e on worksheet "NSN LIST REF", click a button
and have it moved over to worksheet "INVEN". The data that needs to be
moved is in column "e" and "f". The first two cells in column "e" are
titles to be centered on "INVEN" one on top of the other. The third
cell (Panel A) needs to be in column "a" on "INVEN" a space under the
title. A space under that needs to have the word ITEM in column "c".
The fourth to ? cells need to go in column "c" a space under ITEM. In
the selected area it is seperated by Panel A, Panel B, etc... those
need to be in column "a" but the stuff between them needs to be in
column "c". This is what "NSN LIST REF" looks like:

EA-6B QA-1 INSPECTION Box
A-Box (ONE PER EACH FOUR AIRCRAFT)
PANEL A
1
2
3
4
5
6

PANEL B
1
2
3
4
5
6
7
8

This is what I need it to look like on "INVEN":

*__*EA-6B QA-1 INSPECTION Box
*_Centered,_Bold,_&_Underlined=__*A-Box (ONE PER EACH
FOUR AIRCRAFT)

*__*PANEL A

___*__*ITEM

___1
___2
___3
___4
___5
___6

PANEL B

___ITEM

___1
___2
___3
___4
___5
___6
___7
___8

Then I need column "f" of the selected area to go in column "g" next to
the number. The problem is that the areas I select won't have the same
numbers but they are all seperated by Panel or Drawer, A, B, C or 1, 2,
3, etc. Basically I need my list of tools to look like it does in a
publication so I don't have to cut and paste or type it in by hand.


--
Optitron
------------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...o&userid=26729
View this thread: http://www.excelforum.com/showthread...hreadid=573839