vba autofilter, copy, paste to another workbook(sheet1), hide the cell

[lax2734]

Hey all,

Another odd request I cannot seem to figure without recording a lengthy macro.

I have attached the source and destination sheets.

I would like to write a code that would filter column g to show only the available people copy columns a-g in the masterfile and paste to the destination file in the first sheet "monday 830", the first row of titles doesnt have to be copied in each time, it will always be the same.

Then, as i could figure, i would have to clear the filter in column g, hide the column so i could then filter column h to show who is available, copy and paste to destination sheet in sheet name monday 955.

any suggestions? i cannot find anything and the recorded macro is in the masterfile as a macro titled exportByday if that helps at all!

also, hoping to just paste over the data that exists in the sheet each time to avoid any duplicates!

Transportation Masterfile-fix.xlsmTransportation availability by time-UPDATED.xlsx

[MarvinP]

Hi lax2734,

I've created a macro to convert your type of cross tab data to a real Excel table. I've included it in the attached. See the screencast to see how I'd do this problem.
http://screencast.com/t/NRZNP3yBNTi

[lax2734]

MarvinP, thank you so much for this, i am not sure why it never crossed my mind to create a table! I tried looking at the screencast and it came up blank, id love to see it!

THank you again!