The worksheets are attached and I need to extract hundreds of demographic data information from multiple worksheets (attached "Tampa S Dale Mabry" and "Tampa West Swann") on to one Worksheet called "Demographic". I have highlighted the data in yellow from two locations that I need the data extracted on to the "Demographic" worksheet. Please note the red highlights specifies a 1 mile radius, 3 mile radius, and a 5 mile radius. I have included a Macro "button" at the top that I would like to utilize. I want to be able to open a demographic data worksheet (i.e. Tampa S Dale Mabry) and be able to hit the macro "button" on the "Demographic" worksheet to extract the data. Then open a new worksheet (i.e. Tampa West Swann) and hit the button to extract the data on to the "Demographic" worksheet. I have tried doing this on my own but the problem was that data was extracting from the orignial demographic data worksheet and not a new one on a different row. Please Help. I don't want to spend the next year doing data entry and this is due by Friday! Thank you smart people. I will get there one day!Demographic.xlsx Tampa S Dale Mabry.xlsx Tampa West Swann.xlsx
Bookmarks