LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 28th 10, 06:21 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Apr 2010
Posts: 2
Default Pull info from one excel file to another depending on values of O.

I need the formula that can transfer rows based on a value of a cell in a
row into a different excel file. For example:

Part# Jan Mar Oct Total Avg 1st QtrAvg 2nd QtrAvg 3rd QtrAvg 4th
Qtr Avg
913 3 1 1 5 1.6 1.3 0.00
0.00 .33

I want to be able to pull the rows whose values are 1.0 for a Qtr avg. or
a given qty into a separate file perpetually.

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
how do i pull info from one excel spreadsheet to another? WatChaLknAt Excel Discussion (Misc queries) 1 August 3rd 07 07:16 AM
different values depending on how text file is opened notMe Excel Discussion (Misc queries) 6 September 14th 06 08:43 AM
Pull values from each .xls file in dir Duke17 Excel Discussion (Misc queries) 4 May 28th 06 03:23 PM
Pull info from other worksheets Barb Excel Discussion (Misc queries) 5 April 14th 06 02:16 PM
How to pull some info into different sheet? jeffw Excel Worksheet Functions 1 May 4th 05 02:17 PM

All times are GMT +1. The time now is 05:17 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017