ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   web query (https://www.excelbanter.com/excel-programming/311241-web-query.html)

excel_ent

web query
 
is it possible to extract from a sub-tabular level ?

i.e. extract only the last 8 cells in row 3

maybe a dot notation? table1.3.2:9 or the like??

Dick Kusleika[_3_]

web query
 
Nope. You'll have query the whole table onto another sheet, then use
formulas/macros to extract the data you want.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"excel_ent" wrote in message
...
is it possible to extract from a sub-tabular level ?

i.e. extract only the last 8 cells in row 3

maybe a dot notation? table1.3.2:9 or the like??





All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com