LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
OTS
 
Posts: n/a
Default SELECT large amount of data in a worksheet

I have my mathematical model results in excel format every times I run my
model.

Huge amount of data --10,000 rows, with 10 columns.

Now I like to copy certain portion of data into a new workbook for further
analysis.

And the data I wish to select is from F10:F10010 to P10:P10010.

I can always select F10, scroll down and select P10010. This is a bit
cumbersome and takes time.

I cannot assign NAME to these data because every time I run my model, my
range of data that I am interested in could differ -- meaning sometimes it
could be ranging from H5:Q5 to H5000:Q5000.

Is that a way for me to SELECT the data quick .. click F10, the first data
and by another CLICK or so it automatically select CELLS which are BELOW and
to the RIGHT for all cells that with numerical values.

So that i do not need to scroll down the whole workbook every time.

Thank you.









 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
MAKING A CONTRACT FROM DATA FROM A WORKSHEET MCNAB Excel Worksheet Functions 5 July 28th 05 03:13 PM
Move select data to another worksheet Annabelle Excel Discussion (Misc queries) 3 July 27th 05 06:01 PM
Get External Data Web Query new worksheet Nina Excel Discussion (Misc queries) 0 April 14th 05 07:08 PM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"