aloeverawater
New Member
- Joined
- Feb 12, 2018
- Messages
- 2
Hi everyone i have two questions i need help with.
1st. Is when i am using external data that is imported into excel from the web, Hyperlinks on the websites table does not get transferred into excel but instead just text. Is it possible to change this so it imports working hyperlinks. (Using a query, i do not want to use a connection as it will not work for me)
2nd. I have this formula that i wish to fill:
=IF(Sheet2!C2="ASTERIX",Sheet2!A2,"")
Each row the formula is filled the formula should increase by 2.
For example
=IF(Sheet2!C4="ASTERIX",Sheet2!A4,"")
I tried using the fill handle but excel does not seem to notice this trend and instead outputs rising and falling numbers.
Any help would be greatly appreciated Cheers Chris.
1st. Is when i am using external data that is imported into excel from the web, Hyperlinks on the websites table does not get transferred into excel but instead just text. Is it possible to change this so it imports working hyperlinks. (Using a query, i do not want to use a connection as it will not work for me)
2nd. I have this formula that i wish to fill:
=IF(Sheet2!C2="ASTERIX",Sheet2!A2,"")
Each row the formula is filled the formula should increase by 2.
For example
=IF(Sheet2!C4="ASTERIX",Sheet2!A4,"")
I tried using the fill handle but excel does not seem to notice this trend and instead outputs rising and falling numbers.
Any help would be greatly appreciated Cheers Chris.
