Transpose data automatically

I need to copy data form certain cells in different sheets in an excel to another sheet. The last row of data from "veggies, fruit and frozen" into the first available row in the tab "list". Only some information of it, not the whole row.

So far I got a VBA that move into the fist blank row but not sure how to select the last row form the other tabs to copy.

Also would be nice to be able to automatically input date into when the item is added into the "list" tab.

Can anyone advise please?

Thank you

Please Login or Register  to view this content.

Kind regards
Leo

Hi,

Thank you for you help. But I've seen to run into some issues.

I am trying to get copy some cells from the last row of each different sheet but separately, like after a specific command from each sheet.

What I found is that now it copies all of the last rows from each sheet, ending up with duplicates in the Master.

Any guide on how to create a command to include in a button in each sheet that copies certain cells from the last row only in from that sheet?

Keeping the date in the first cell.

Thank you