G
GTyson2
Is there a way in VB code so if a cell in another workbook has color
formatting it will automatically fill in another field on the first workbook?
Example.
Workbook1.xls contains list venders, unique vender numbers are in column B,
and in column N represents the vender being paid, while column O represents
the check to the vendor is on hold.
Workbook2.xls contains list of all venders and all payments. Column C
contains the unique vendor numbers, and column T contains when the vender was
paid, and if the cell in column T is highlighted then the check is on hold.
So I would like something that will on command look up Vender from
Workbook1.xls and in column N give me the date the check was issued, and then
in column O I want it to tell me if the check is on hold (aka cell in column
T in workbook2.xls is highlighted)
Possibly making a button so it only does that when the button is press?
formatting it will automatically fill in another field on the first workbook?
Example.
Workbook1.xls contains list venders, unique vender numbers are in column B,
and in column N represents the vender being paid, while column O represents
the check to the vendor is on hold.
Workbook2.xls contains list of all venders and all payments. Column C
contains the unique vendor numbers, and column T contains when the vender was
paid, and if the cell in column T is highlighted then the check is on hold.
So I would like something that will on command look up Vender from
Workbook1.xls and in column N give me the date the check was issued, and then
in column O I want it to tell me if the check is on hold (aka cell in column
T in workbook2.xls is highlighted)
Possibly making a button so it only does that when the button is press?