Transfer data from Database sheet back to Input sheet

Hi,

My first time posting on the forum!
I hope someone can help, I am looking for VBA code to transfer data (using a button) from a "Database" sheet back to the "Input" sheet without having to populate the Input sheet manually for re-calculation.

1. In the attached example workbook I have the VBA code that can send the data from the "Input" sheet to the "DB" sheet when you press "Save to Database" button, but now I need a code that can work in the reverse and send the data back from a specific row in the "DB" sheet by selecting a cell in column A to "activate" the row data and then press the "Load Inputs" button to send the specific rows data back to the "Input" sheet and re-populate the corresponding cells.

2. After the transfer back to the "input" sheet has been successful the code should then delete that specific row in the "DB" sheet as it will be re-saved to the DB after the inputs have been changed/checked to prevent any duplicate data information

This is a partial solution . Since the database is in "Table form" the deletion part swipes all the rows below it too...
You could convert the database into a flat table.

Please Login or Register  to view this content.

Thanks, it does work to get the DB cells to Input sheet cells however it should not transfer the data in the grey cells as these are formulas in Input sheet. It should just transfer the data from columns B, C, E, F in the selected row

@ rcm

thanx, please advise how to link to button "Load Inputs" in DB sheet

I ran the macro, but had the following problems:
1. line Sheets("Input").Cells(10, 3) = Sheets("DB").Cells(Target.Row, 5) of the code populated incorrectly. it placed the data in C8 instead of C10 on the Input sheet.
2. did not delete any of the rows (this is not important and as you said it might delete all rows below the selected row - this would not work for me having other data deleted as well)

@rcm please ignore my previous post with the errors I got, seems I had some glitch that did not make it work right!

I later sat again and tried your code again and it worked great!

In your code how would you link the code to only activate when the "Load Inputs" button in DB sheet is pressed?