[RESOLVED] [Excel] Copy data from specific cells to another workbook

[Bamahut]

Hi,

I'm having a specific request that's driving me crazy for now a couple of days.

I'm advance in excel but it's been years since I work code in VB.

The problem I'm facing is that my Coworker want to have specific data that's spaced out on his spreadsheet to be copied into a separate workbook to keep track of work being done at work.

I've been lurking around Google but just can't find anything close to what I need the code to do.

I've attached a screenshot of the tables I need to copy.

The cells I need to copy to the new workbook are F6,F8,F10,F12,F14,P28,F36

I would be good if they were copied as a row and not as a column as well.

Thanks in advance