I have a simple excel that has two sheets. One FORM and second RATE
Both have Tables.
My need is, when the table in sheet FORM fills then automatically fill and the table at sheet RATE
I am trying to make it happen but #Value keeps coming. I understand that my first table starts from Row 17 and the second from row 1
What can I do?
The formula am using is =Invoice[@[PCS]:[PCS]]
I hagve attached the excel if it can help