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.
Thanks 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.
Thanks All,
