how to pull data from a sheet named as per value in the cell on a
different sheet
I have a multiple sheets in a workbook for orders on a same format and it
will keep adding. Sheet name will be order number.
I wants to create a Quotation sheet with a different format but same
information from any order i want to print the quotation agaisnt.
i am looking for a code or formula help to pick the information from Order
sheet as per number / name on the quotation sheet. i.e. every time i
change the number in a specific cell it pulls information from respective
order sheet only.
will greately appreciate your help Thanks
Naman
No comments:
Post a Comment