11-10-2010, 10:32 AM
Hi Sekhar,
Please let me know whether I am getting your question correctly or not.
You have a excel sheet in which 2nd & 3rd columns contains hyperlinks (the value of hyperlink is a number) for each row.
Now you have to click over each & every hyperlink. If you click over a link it opens a new excel sheet. You have to count the number of rows of new sheet.
Now I have two questions.
1. Is there any relation between the ‘hyperlink value’ & the ‘rows count of the sheet’ which comes after clicking over the hyperlink?
2. Is the row count & hyperlink value is changing very frequently?
Please let me know whether I am getting your question correctly or not.
You have a excel sheet in which 2nd & 3rd columns contains hyperlinks (the value of hyperlink is a number) for each row.
Now you have to click over each & every hyperlink. If you click over a link it opens a new excel sheet. You have to count the number of rows of new sheet.
Now I have two questions.
1. Is there any relation between the ‘hyperlink value’ & the ‘rows count of the sheet’ which comes after clicking over the hyperlink?
2. Is the row count & hyperlink value is changing very frequently?