data transfer

Try the attached file. Before you click the button, format cell A2 on the "Fire 1 Inventory Log" sheet as a date.

Hi again,

The green shaded areas in the attached workbook are synchronised - adding an item in the range C2:CX2 on the Log worksheet will cause that item to appear in the range D4:D103 on the Inventory worksheet - the entire range E4:E103 is copied to the Log worksheetwhen the "Submit To Log" button is pressed.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hello Steddas,

You won't have to alter any thing in the code. You'll only have to add a few more headings for the newly added equipment in the Log sheet and ensure that your Wingding font continues further along to cover the new headings. As long as you have data validation in each cell in Column E (Inventory sheet), this part of the code will do the rest for you:-

Please Login or Register  to view this content.

However, it would be worthwhile changing this line of code:-

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

This will cover the fact that you may not have an entry for Column C in the log sheet which could end up mis-aligning your rows of data.

Or, you could just use Greg M's code in post #7, as, as far as I can tell, he has all angles covered.

I hope that this helps.

Cheerio,
vcoolio.