Data transfer from two different sheets based on drop down menu using a button

Good afternoon (my time),

I'm having an issue with a version of the attached template with sorting the data. I think my problem is in how I'm transferring the data over.

Right now I'm using a series of if/then statements, but I'd like to use the "sort" button on the "easy buttons" sheet to pull the information over from the "exceptions" and "log" sheets to the "Data for BD" sheet.

The information I need are (in order) columns C,E:M (starting on row 3), I need blanks to transfer over as a blank, and I need the data to transfer over only if "automated" is selected in column "A".

I have a frozen headings row in row 1 of the "Data for BD" sheet.

Thank you very, very much!

hi rowlandjp, please check attachment, activate sheet "Data for BD". The easiest option to make it

PS. It's a bad idea to format the whole sheet with borders ...

Awesome. Thank you!

I adjusted the borders. It was laziness on the part of my predecessor (and a bit from me).

I ran into an error when transferring the code over to my workbook (run-time error '9' subscript out of range). I adjusted "exceptions" on the one line to the actual tab name "STATs, Rushes, Re-hybs, Add-ons", but I didn't see "log" anywhere to change to "hyb log". The line the debugger is flagging is: With Sheets(vl).UsedRange.Resize(, 13)

Can you help me adjust please?

Thank you very much!

this line part is responsible for sheet names

Please Login or Register  to view this content.

Change it to:

Please Login or Register  to view this content.

The code would get data from all the specified sheets.

I'm still getting the same error (please see attached jpeg). I also tried replacing the "," in the code you gave in the last message w/ "hyb log". It had the same error message, and only pulled information from the "STATs, Rushes, Re-hybs, Add-ons" sheet.

The only two sheets I need the information from are "hyb log" and "STATs, Rushes, Re-hybs, Add-ons".

Thanks again for your help.

I thought "STATs, Rushes, Re-hybs, Add-ons" are four different sheets separated by coma

Then is should be:

Please Login or Register  to view this content.

Great. Thank you!

Do you know why there is such a big separation between the "hyb log" and "STATs, Rushes, Re-hybs, Add-ons" information?

I think I have an idea. I don't want to ignore blanks unless column "c" is blank. Then the entire row should be ignored.

Very sorry for not being more clear on what I wanted.

Thank you for all of your help.

please check attachment, criterias: A column - automatic, C column - non-empty

Perfect. Thank you!

Originally Posted by rowlandjp

Perfect. Thank you!

for what this worksheet and form was made for ??

Separating data out from a single source for manual or automated processes.

Hi waterserv, do you happen to know of a way to modify this to make it work as a macro?

I'm having some problems with it now as I have to save the tab as a new workbook. The code is creating an error (in since, I presume) the tab is no longer connected to the worksheet it is pulling info from.

Thank you!

hi, do you mean sort of that, press Run button on "Data for BD" sheet

Wow, that is a really clever work around!

Part of the export macro is putting it in a specific folder w/ a specific name so I might take that part out, but thanks for the adaptation!