Hi all,
I am working on a Workbook to be able to pull data from a source file and auto fill based on what location is selected. In the attached example, sheet2 has the format I am looking to fill. The yellow cell contains a drop down of the location options and sheet3 has the source data. The difficultly for me is that the source data is from an external feed that puts it in this unusual format with locations in column 'A' and the needed data in columns 'I' through 'Q' depending on whether the location is open from Sunday through Saturday or Monday through Saturday. What I am looking for is when I select a site from the drop down on sheet2 (cell in yellow), it will find the data for that site (from sheet3) and fill in the data for each of the three fiscal weeks and each day on sheet2. I've tried a variety of statements including VLOOKUP, FIND, IF/THEN/AND, with no luck, so any help would be greatly appreciated, thanks!
Bookmarks