VB data sorting macro unable to sort correctly

Hi

I don't have 2007 and am using a converter. Can you please turn of the JIT debugging, or convert to a 2003 format for your example file.

To clarify, you just want to break out the data from sheet commitments to separate sheets, based on the value in column I. If the sheet exists, then append the data. If it doesn't exist, then create the sheet, then append the data.

rylo

Hey,

Here is a 2003 format version.

Also i am using VBE so i don't think JIT debugging is enabled?

Thank you

Hi

Exactly which sheet are you trying to burst out? Actuals or Commitments?

Looking at the example, the output sheets seem to match the Actuals structure, but your post says you are trying to use Commitments.

Which sheet is it? And do you want to remove any existing data on the output sheets before bursting out?


rylo

Originally Posted by rylo

Hi

Exactly which sheet are you trying to burst out? Actuals or Commitments?

Looking at the example, the output sheets seem to match the Actuals structure, but your post says you are trying to use Commitments.

Which sheet is it? And do you want to remove any existing data on the output sheets before bursting out?


rylo

Hey,

I would like to generate Actuals and then append sorted commitments under Actuals if the worksheet already exists or create a new worksheet if it doesn't.

The code that deletes all the worksheets in commitments is for testing purposes and can be removed.

Thanks

so what items from commitments are to be moved to any existing sheet, and where do they go?

rylo

Originally Posted by rylo

so what items from commitments are to be moved to any existing sheet, and where do they go?

rylo

Each item in commitments has a 'code'.
Those coded commitment items need to be sorted into their corresponding worksheet just above Actuals data in its own table.
If no worksheet for that code exists excel should create one and insert the data.

Hope that makes sense.

Hi

Using your example, the code 2200 has a sheet and an item in the commitments sheet. There are 2 values for this code: Date (E3) and Committed value (B3).

Which of these values goes across to the sheet 2200, and exactly where does it go? Give an input and output cell reference, as the heading in the commitment sheet don't match the headings in the 2200 sheet.

rylo

Originally Posted by rylo

Hi

Using your example, the code 2200 has a sheet and an item in the commitments sheet. There are 2 values for this code: Date (E3) and Committed value (B3).

Which of these values goes across to the sheet 2200, and exactly where does it go? Give an input and output cell reference, as the heading in the commitment sheet don't match the headings in the 2200 sheet.

rylo

The entire commitments table with the corresponding code needs to be copied over just below the actuals table.

Each Code sheet should have an actuals and commitments table. Even If there are no values for either actuals or commitments.

Hi

Put this in the commitments sheet code area.

Please Login or Register  to view this content.

Does that give you what you are trying to achieve?

rylo

Sorry shg.

Yes thank you, that is perfect rylo

+ rep

Hi

Great. Can you go back to the original post, and mark as SOLVED.

thanks

rylo