Hi Excelperts,
Need help on following try to create a dashboard.
Have herewith attached a sample file
But first need to match data from Column H to A of Sheet 'Oct-19'
On dashboard need following data are to be Displayed with the help Index on Sl-No in column G of Sheet 'Oct-19'
& lock/protect the data sheets "User Front only Dashboard should be available"
Product Name
Batch
Rate
Qty
Date
Invoice#
Difference of Qty from column B & K of Sheet 'Oct-19'
from Column G,H,I & J & A,B,C,D,E,F & G
Appreciate your inputs/help.
Link to sheet https://docs.google.com/spreadsheets/d/1A7bG-_E9T3GK7-V1ii60eoLEv36wcVBK_iAVevm1KY8/edit?usp=sharing
Thanking you,
Need help on following try to create a dashboard.
Have herewith attached a sample file
But first need to match data from Column H to A of Sheet 'Oct-19'
On dashboard need following data are to be Displayed with the help Index on Sl-No in column G of Sheet 'Oct-19'
& lock/protect the data sheets "User Front only Dashboard should be available"
Product Name
Batch
Rate
Qty
Date
Invoice#
Difference of Qty from column B & K of Sheet 'Oct-19'
from Column G,H,I & J & A,B,C,D,E,F & G
Appreciate your inputs/help.
Link to sheet https://docs.google.com/spreadsheets/d/1A7bG-_E9T3GK7-V1ii60eoLEv36wcVBK_iAVevm1KY8/edit?usp=sharing
Thanking you,