Transfer data from certain columns in the last row of data to separate worksheet

[infoanalyzer]

Hi All,

The attached workbook (projects.xlsm) contains two worksheets: tblProjects and tblPO.
Projects.Anon.zip

I’m trying to transfer data from certain columns in the last row of data in tblProjects to specific cells in tblPO, where the data entered in tblPO simply overwrites earlier entries. I’ve added a simple script to tblProjects to show you what I mean, but this is merely an example and only works on the first row of data.

Have also attached a second workbook, which projects.xlsm references.

Thanks in advance for taking the time to read this and for helping me out :)

Karen

[JBeaucaire]

Sure, that's doable. The simple script you created doesn't seem to put values into columns on tblPO, it puts them into that form you have mocked up. As such, that would only work one row, but I'm sure we just know exactly what you're doing here yet.

1) What would trigger the move?
2) Are we simply moving some random row from tblProjects into that form?

[infoanalyzer]

Thanks looking at this Jerry.

Sorry for not being clearer in my original post.

The big red button at the top of the tblProjects worksheet is the trigger.

tblProjects is an ongoing record and could contain any number of rows. Would like to copy data from the last row under the headings

"Project Number" in tblProjects to "JOB NO.:" (B5) in tblPO
"Language from > to" in tblProjects to "LANGUAGE PAIR:" (B7) in tblPO
"Service" in tblProjects to "JOB TYPE: " (B4) in tblPO
"Qty. New" in tblProjects to "New:" (B11) in tblPO
"Qty. Rep." in tblProjects to "Repetition (perfect/100%, etc.):" (B12) in tblPO
"Qty. Fzy 95-99%" in tblProjects to "Fuzzy (95% - 99%):" (B13) in tblPO
"Qty. Fzy 85-94%" in tblProjects to "Fuzzy (85% - 94%):" (B14) in tblPO
"Qty. Fzy 75-84%" in tblProjects to "Fuzzy (75% - 84%):" (B15) in tblPO
"Qty. Fzy 50-74%" in tblProjects to "Fuzzy (50% - 74%):" (B16) in tblPO
"Deadline" in tblProjects to "DEADLINE:" (B6) in tblPO

To summarise, the data in the above mentioned columns of the last row of tblProjects should be copied and overwrite the data in the above mentioned cells of tblPO.

[JBeaucaire]

If you simply want the form on tblPO to always show the latest entry, you don't need VBA for that.

B5: =INDEX(tblProjects!B:B, COUNTA(tblProjects!A:A)+1)
B6: =INDEX(tblProjects!L:L, COUNTA(tblProjects!A:A)+1)

...etc.

[infoanalyzer]

Thanks very much

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.