hello,

i am using excel 2007, and i have invoice format in sheet 1 as shown below.
..Click image for larger version. 

Name:	INVOICE.jpg 
Views:	29 
Size:	82.9 KB 
ID:	1196

now i need the code for save button for following problem:

Problems:

the first problem is when i press the save button it should generate the pdf file of sheet 1, and have a link to open this newly generated file in sheet 2
and it should ask me for the file name at the time of saving it,

now the second problem is it should save the link in next row each time
for example :
first it save link in sheet 2 a1
than next time it should save link in sheet 2 a2
than next time it should save link in sheet 2 a3
and again and again...

pls help..