Parse_data Macro

[miradest]

Hi there.
I have a Workbook with a sample template BUP PLANNING.xls with sheets NEW and CONSOL.
I understand that we can use parse_data Macro to split the dates into different worksheets with the dates tab.
i.e. in cell A2 of CONSOL worksheet, date is 1 May. I would want to create a worksheet with tab name 1 May.
In the CONSOL sheet, I have 26 dates.
Ultimately i want to create 26 worksheets with all the dates on the tab.

However, my challenge is that for all these worksheets, i want to have create a table like the one in NEW worksheet.
Plus, cell E4 of these worksheets to contain the date same as the tab and C10 to have the MAWB for that date referred to CONSOL worksheet.
Can anyone help?
I hope my explanation is clear.

[stnkynts]

Good job explaining. Give this a try:

Please Login or Register  to view this content.

[miradest]

ahh. stnkynts it works thanks!! however forgot to do extra thing. Cell E4 needs to indicate date as per each tab.
means eg for 4apr tab, cell E4 should indicate 4 apr as well.

[stnkynts]

Sorry about that. I put C4 instead of E4. Try this:

Please Login or Register  to view this content.