Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search Sheet Names Across Excel Files
I have two excel files TableA.xlsx(http://www1.zippyshare.com/v/99115783/file.html) and Student.xlsx (http://www11.zippyshare.com/v/88884922/file.html)
I have to query data from TableA.xlsx and populate it in Student.xlsx I am doing the following in Student.xlsx: Birth Date is entered and then Test Date is entered. Age is calculated as TestDate - BirthDate. Up till here it is Done Since the Age is 6.9 in our example (plz see Student.xlsx), I want to query that sheet in TableA.xlsx in which the Age falls into the range, Eg: for 6.9, lookup the range 6.8.0_7.1.30, i.e. 2nd sheet of TableA.xlsx How do I do it? One way I know is to use lookup but these are two different excel files. How to take this Age and search excel sheet names to find the right one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find sheet names without opening files | Excel Programming | |||
search sheet names containing phrase then copy to cell | Excel Programming | |||
Can I search sheet tabs for names? | Excel Discussion (Misc queries) | |||
How do I import Names of Windows files into an Excel Spread sheet | Excel Worksheet Functions | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |