Hie All,
So basically i am making invoices from a master file where all the necessary inputs are there, what i want is automation of the invoices, the master file contains the following data:
B2 C2 D2 F2 G2 J2 K2 L2 M2 P2 SrNo Date Quot Date Inv Product StockC ProdcutC Qty Price
And the file where it should be pasted is, as follows in Sheet-1:
C8 G8 B25 G27 H27 C32 C33 C2 D2 J2 M2 P2 K2 L2
And In Sheet-2:- E8 E10 F2 G2
And also all these should be pasted special as only values not as links,
So far what i have made the code is it would get the desired values from all those and paste special from the master file for row 3.
What i want is when i run the macro in the blank invoice sheet, it would ask me enter SrNo which would be from column B, and when i enter 1, it would look for SrNo=1 and then extract the data from the above and paste it as above.
Also The file name in which these data would be pasted would be changed, for instance for Sr No 1, the file would be 1INV.xlsm, for Sr No 2 it would be 2INV.xlsm and so on..
Thanks All,