VBA CODE TO SPLIT SHEET1 INTO SEPERATE TABS

  • Posted:
  • Proposals: 1
  • Remote
  • #2586799
  • Awarded
Marion M.
has already sent a proposal.
  • 0

Description

Experience Level: Intermediate
Hi Marion,
I hope you are well?

I have another VBA challenge which I need a code written to process several hundred excel files on a windows machine only this time.

Please can you provide a quote on how much this would cost?

The code required is to Split Sheet 1 into the seperate tabs in the example file in the data sequence order per sheet 1.

Example Output File:

Sheet1 contains master output which we need splitting out into each of the below tabs in the same order as sheet1.

I have created the tabs which are needed to be created and called.

SEL
DST
EHL

Ticket Type:

This shows the various ticket types that can be outputted in one go as there are 47 variations that can be outputted

Issue:

Not all Tickets that go into the SEL,DST or EHL tabs split can be outputted in sheet 1.
So the code needs to factor this in.

For example Sheet 1 may only contain SEL and nothing else.
For example Sheet 1 may contain SEL and DST
For example Sheet 1 may contain EHL and nothing else

If the data exported in sheet 1 does not require a tab creating for example there is no DST data in column D then you dont need to create the tab.

We only need the SEL, EHL & DST tabs creating if code splits the data.

I appreicate the brief may not be clear and you can call me on my 07983465287 if needed as it might make more sense me telling you.

Kind regards

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.