Macro to copy/paste and replace info to another part of a sheet

[GregHorn27]

Hi!

I am building a worksheet to help the farm that I work on to track progress on various tasks and I need the help of the folks on this forum that are much smarter than I am.

Per the screenshot, you'll see that I have folks enter various information and what I would like to happen is that they click 'Submit' and that data gets pasted over in the HISTORY side of the sheet in reverse chronological order - the newest info will be at the top.

There are various Data Validation dropdowns and, in some cases, I want to replace a 'Y' chosen in a dropdown for what that "Yes" represents.

A 'Y' in F6 = "Pau"
'Y' in K6 = "Broadfork"
'Y' in L6 = "Torch"
'Y' in M6 = "Tilth"
'Y' in N6 = "Compost"
Also, Z5 will always be whatever 'Entry Type' is in B3

If columns are left blank (either because they're hidden or because that info wasn't entered), I would not like to paste a clear cell. I would rather only have the shortest number of cells in a row that are needed, even if the data in each column changes from row to row in the HISTORY section. The data is self-explanatory, so it shouldn't make a difference.

Finally, I already have some code in the sheet to hide certain columns based on the 'Entry Type' chosen and also to clear contents and update to today's date when 'Entry Type' gets changed. I've included that code below.

This seems like a pretty complex request (to me, at least :-), so I greatly appreciate any assistance any of you can provide!

Many Thanks,
Greg

Screen Shot 2014-11-11 at 4.17.20 PM.jpg

Please Login or Register  to view this content.

[GregHorn27]

One more screenshot to show when almost all of the rows are shown

Screen Shot 2014-11-11 at 5.14.25 PM.jpg

[jolivanes]

Attaching screenshots means that people willing/able to help need to create their own workbook.
I think that you'll get responses if you attach a sanitized workbook with a clear explanation and a before and after in it.

[GregHorn27]

Forgive me jolivanes, but what do you mean by a sanitized workbook? Also, was my explanation not clear enough? If not, what other info do you think I should provide? Finally, before and after what?

As you can see, I'm a bit confused. Attached is the workbook.

Thanks for the guidance!

Farm Logbook.xlsm