Hi,
I have an Excel file with a three-sheet. In the first sheet I must apply VLOOKUP function twice in columns C and D.
Formula for column C is:
= VLOOKUP (A2 & "Count," Ulaz! A1: D10000, 2, FALSE)
Sheet "Ulaz" is a dynamic table where the preliminary counting how many PartNo entered for each PartNo.
Formula for column D is:
= VLOOKUP (A2 & "Total" Out! A1: D10000, 2, FALSE)
Sheet "Izlaz" is also a dynamic table where the preliminary sums Quantity for each PartNo.
When do VLOOKUP need to copy an existing file to a new grantee will specify the name.
How to automate this with the help of VBA.
Thank you.
I have an Excel file with a three-sheet. In the first sheet I must apply VLOOKUP function twice in columns C and D.
Formula for column C is:
= VLOOKUP (A2 & "Count," Ulaz! A1: D10000, 2, FALSE)
Sheet "Ulaz" is a dynamic table where the preliminary counting how many PartNo entered for each PartNo.
Formula for column D is:
= VLOOKUP (A2 & "Total" Out! A1: D10000, 2, FALSE)
Sheet "Izlaz" is also a dynamic table where the preliminary sums Quantity for each PartNo.
When do VLOOKUP need to copy an existing file to a new grantee will specify the name.
How to automate this with the help of VBA.
Thank you.