Split file upload into 2 tabs based on criteria

[cartica]

Hi,

Below is a code snippet from the macro. I am pulling the file Brazil Cap Gains Trade details, and bringing into my worksheet with multiple tabs. I would like to be able to look at the file I am pulling and if column B is blank (cell b4 and forward), then no data is brought into worksheet tab "Mast" or "INV" (ignore the row). However, if there is data in column b, then look to column G. If Column G has the name "Master", then put it into the next available row below the header in tab "Mast". And If Column G has the name "Investors", then put it into the next available row below the header in tab "INV". Also, if data is pulled into "Mast" or "INV" then I would like a formula from a previous row to be copied down into columns

Please Login or Register  to view this content.

corresponding with the rows pulled into "Mast" or "Inv".

Please Login or Register  to view this content.

Thank you

[cartica]

Is there anything I can clear up or help explain better?

[cartica]

Wanted to follow up as I have not seen any replies yet

[cartica]

I am hoping someone can advise

[AliGW]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.