Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Transfer B/W Excel with Calculations
Hi,
I have two excel sheets, A.xls and B.xls I have lots of data in A.xls and need to consolidate them in B.xls. What i want: 1. Get the file name from a column given in B.xls (cause the 1st excel name can be anything) 2. Once this is done, next i need to get a count from a range depending on the condition, say like i have columns M:U filled with data (value < 100) and i need to get the count if data is between 60 and 100. Just count. How do i do this? And more complex calculations will follow depending on the success of this. What i like to do is to select the filename and then proceed. Can someone help. Thanks.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer Excel data into Word, including text box data | Excel Discussion (Misc queries) | |||
Transfer data from Excel to Access | Excel Programming | |||
Transfer Data from Excel 2000 to the Access data base | Excel Programming | |||
TRansfer of data from excel | Excel Discussion (Misc queries) | |||
Transfer / combining Excel data | Excel Discussion (Misc queries) |