Put in respective worksheets

S

Steved

Hello From Steved

I have a worksheet named Audit Report which is full off data. A6:Q255
In column A I have a name called City, Roskill, Papakura, Wiri, Shore, Orewa,
Swanson, Panmure, and Waiheke. Also I've named the worksheets City, Roskill,
Papakura, Wiri, Shore, Orewa, Swanson, Panmure, and Waiheke.

Please how do I put the value in each respective worksheet with a heading
which is A5:Q5.

For example in row A6:Q5 I have City, in row A7:Q7 I have Roskill and so on.

Thankyou.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If I use 10 macro is ok but if I use 10: Auckland City Depot it is 3
Turn off Security Alert dailog box for office 2007 10
To named Sheets 4
Creating Email using Windows XP, Office 2007, Outlook 2007 "worksh 0
Create 2nd, 3rd , 4th worksheet and so on 2
I need a liitle help please 3
IF , Then 4
Make them work on the Each cell Value 7

Top