Can anyone help with this vba scripting for me please.
The attached file has a department in column A, I would like to extract that raw data separated into new sheets based on the department name.
The end result being a new sheet per department with only that department's data in it.
All data from rows A to W contain data, however I've removed data from C to W from the file.
Hope you can help.
thanks
Last edited by Christopherdj; 01-05-2015 at 04:26 AM.
Hi Christopherdj,
try this
Please Login or Register to view this content.
Thank for the reply, however the data does not replicate. All Sheets are created which is what I required, but the data in the remaining columns B to W needs to remain in their respective columns. What you supplied places some of the data in column C, nothing in the remaining columns.
It is close to what is required, but not quite.
Department 1 should contain data in columns C, E, I, P, S and V respectively, kept the same as sheet 1.
just fill header row (from A1 to W1) and try again
Thank you for that, adding the headings works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks