UNFI
10-02-2020, 12:47 AM
Hi. I am new to VBA.
Could someone help write a simple code so I can understand how it works?
What I am looking for is a VBA code to help copy updates from SHEET2 & SHEET3 to current report SHEET1. It will copy new information to a new row after the last used row based on the Sheet2 Column F.
Is this do-able? Thank you in advance for any help.
Sheet2 Column F --> Sheet1 Column A (Any new data based on these 2 columns data should be adding entire row to Sheet1 after last used row)
Sheet2 Column X --> Sheet1 Column C
Sheet2 Column L --> Sheet1 Column F
Sheet2 Column T --> Sheet1 Column I (overwrite Sh1 Col. "I" contents). EXTRACT Date ONLY (MM/DD/YYYY) from Col. "I" into Col "G" only if the word "DELIVERED" appears in Col. "I".
EXTRACT Date ONLY (MM/DD/YYYY) from Sheet2 Column T-->Sheet1 Column G
Sheet2 Column F --> Sheet1 Column A
Sheet3 Column AR--> Sheet1 Column K (must copy hyperlink)
Could someone help write a simple code so I can understand how it works?
What I am looking for is a VBA code to help copy updates from SHEET2 & SHEET3 to current report SHEET1. It will copy new information to a new row after the last used row based on the Sheet2 Column F.
Is this do-able? Thank you in advance for any help.
Sheet2 Column F --> Sheet1 Column A (Any new data based on these 2 columns data should be adding entire row to Sheet1 after last used row)
Sheet2 Column X --> Sheet1 Column C
Sheet2 Column L --> Sheet1 Column F
Sheet2 Column T --> Sheet1 Column I (overwrite Sh1 Col. "I" contents). EXTRACT Date ONLY (MM/DD/YYYY) from Col. "I" into Col "G" only if the word "DELIVERED" appears in Col. "I".
EXTRACT Date ONLY (MM/DD/YYYY) from Sheet2 Column T-->Sheet1 Column G
Sheet2 Column F --> Sheet1 Column A
Sheet3 Column AR--> Sheet1 Column K (must copy hyperlink)