Forum Discussion

Zia Siddique's avatar
Zia Siddique
Copper Contributor
Aug 11, 2018
Solved

VBA - Splitting worksheet by Dept

Hi   This is a complicated task that requires a VBA expert.  I have attached a file for you to review. What I would like is a VBA code to be able to take the data and split it into separate workshe...
splitting worksheet
VBA
  • Man Fai Chan's avatar
    Man Fai Chan
    Aug 12, 2018

    I do not modified the program but just insert more comment for the changes. Hope you can learn it. 

Zia Siddique's avatar
Zia Siddique
Copper Contributor
Aug 12, 2018

Hi Man

Thank you for this I am very grateful.  It works brilliantly.  I have a few questions regarding this code.  The data file was a test file.

 

Can I ask when I am working with these sort of files the range of the data will be different ie the data might start in cell A1 or P1.   The number of columns used would be different ie the data may go from column K to column U.  The number of rows will also vary depending on the data.  The subtotal as a result would be in different cells each time I run the report.

 

What part of this code needs to change in order to reflect the above variations.

 

Look forward to your reply.

 

Zia

siapar's avatar
siapar
Copper Contributor
Aug 20, 2018

I'm trying to remove it from this section
I'm sending a photo

Resources