Needed to fill a data set with PO line quantity with duplicate value below.
Visual Basic Code just works magic here.
Here Is the Link
http://www.extendoffice.com/documents/excel/771-excel-fill-blank-cells-with-value-above.html#a2
Wednesday, October 28, 2015
Friday, October 23, 2015
How to use V Lookup
Every time some data migration activity comes up, We just go on sending mail to technical guys.
Every thing is there in data base and we have functional data. We need to match up data and give it to process to tech guys.
V look up comes handy when u have 2 set of data tables and u need to match the value of 1 column value to other set of data and retrieve information from 3rd column correspondingly.
Following You tube vdo is very much handy to learn the process and apply the V Look up feature in Excell.
Here is the link
Excel 2007 Tutorial VLOOKUP
Every thing is there in data base and we have functional data. We need to match up data and give it to process to tech guys.
V look up comes handy when u have 2 set of data tables and u need to match the value of 1 column value to other set of data and retrieve information from 3rd column correspondingly.
Following You tube vdo is very much handy to learn the process and apply the V Look up feature in Excell.
Here is the link
Excel 2007 Tutorial VLOOKUP
Subscribe to:
Posts (Atom)