Ok, I need a little help please. I have a master file along with 9 other worksheets in a work book. I am wanting to make a script or function, not sure what to use. I have a list of "officers" and each officer has their own worksheet. So within the master, all officers are listed, and from there I would like to seperate them into their own worksheet. Any ideas on how to go about this?
Thank you for your time and help.
Why not have a MASTER worksheet and 9 other "dependant" worksheets - one each for the other officiers For example: Worksheet SMITH
The MASTER worksheet would reference the other worksheets. For example, to reference worksheet SMITH cell E6, the formula would be: +SMITH!E6. Use the same type of formulas for all of the other "dependant" worksheets
Whatever is entered on the "dependant" worksheets would be reflected on the MASTER worksheet
No macros or coding required
Click on star (*) below if this helps
K M,
It can create problems if a row of data is deleted in the dependant worksheet, in that case, it will show as a blank line in the master file. We can get that plugged as well, using the if function but it can get messy. But sometimes, macros might make it easier to work with, since it all happens on the click of a button.
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]
Here is what I am working with. Sorry if the screen is huge.
\1
Thank you both for the quick responses.
A jpg will not help us much. Please upload an excel file.
Others can help with macro coding
Let see if this works, if not please let me know.
Bump any more suggestions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks