PDA

View Full Version : Populate data from 2 columns



omegaboost
08-16-2016, 11:52 PM
Dear All,

If I have the table with the data Date of transaction, Operator, RCP#, INV# also Date of Payment and I want to populate the data by the date of transaction and Date of Payment, is it possible to do that with VBA? For example, if I type the date 16/8/2016 then in the #RCP will show 1234, 2345 and in INV# will show 5555.

Also, how to make every cell in column Date of transaction will fill with date as in cell F1 and every cell in column Operator will fill with data in G2 by input the cell in column Type. So, when I type “a” in cell B5 then Cell C5 will show the date as in F1 and cell D5 will show the data as in cell G2.

Thank you
Omegaboost