I am working with an excel database that has many (over 50) sheets. I need to make an excel spreadsheet that will compile only specific pieces of data from each of these sheets.
Example: Each sheet represents a school and I need to have on a seperate sheet, the school name and the HIV/AIDS Resource Contact and the Sexual Minority Contact.. along with both of these contacts phone numbers. How can I do this?
This can be done. Why dont you attach a sample file with the cell ranges which need to be copied?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Ok here is a sample (three sheets from the actual database) THANK YOU SO MUCH! I've been going nuts trying to get this.
I need B1, C33, E33, J33, C38, E38, and J38 on another sheet
Hi,
Attached is an example that might work for you.
HTH
Steve
SchoolResources.xlsx
Here is your workbook modified.
HTH
Steve
SchoolContacts.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks