Hi Everyone,
I'm having a bit of trouble with a project that I've recently been tasked with at work.
Basically, I have 4 worksheets that each contain a list of situations/instances with about 10-15 fields (columns) that are continuously updated, where each row would be an independent situation/instance. These worksheets are titled "FCAC," "Members," "CRM," and "Other", respectively. I will henceforth refer to these spreadsheets as "info. lists."
I then have one master spreadsheet called "Overview", which ideally would become a "master list" which displays all of the situations/instances from the 4 "info. lists" in one spreadsheet.
Ideally I'm looking for a way to simply copy the values from the rows in each "info. list" (excluding the column titles - as they are identical throughout all of my worksheets) to the main "Overview" list.
Where it gets a little complicated is that I need to design the code so that my colleagues can, for instance, add/remove a situation/instance to any one of the 4 "info. lists" and then be able to see this addition automatically and immediately reflected on the "Overview" spreadsheet. Alternatively, I wouldn't be opposed to requiring the user to click an "Update Overview Sheet" button that would be assigned to the Macro that would accomplish the updating/transposing of the data, if it would be necessary.
I should mention that I am using Excel 2003. I have some prior programming knowledge with regards to PHP, ActionScript, HTML, etc., although to be honest it was more of a personal hobby and I haven't been programming for a while. I have next-to-no knowledge of VBA and Macros, but I am a quick learner and given my background of programming I do not think that learning another language would be exceptionally difficult.
If you need me to clarify anything that I have said please do not hesitate to ask.
Thank-you in advance for your help,
Scott
I'm having a bit of trouble with a project that I've recently been tasked with at work.
Basically, I have 4 worksheets that each contain a list of situations/instances with about 10-15 fields (columns) that are continuously updated, where each row would be an independent situation/instance. These worksheets are titled "FCAC," "Members," "CRM," and "Other", respectively. I will henceforth refer to these spreadsheets as "info. lists."
I then have one master spreadsheet called "Overview", which ideally would become a "master list" which displays all of the situations/instances from the 4 "info. lists" in one spreadsheet.
Ideally I'm looking for a way to simply copy the values from the rows in each "info. list" (excluding the column titles - as they are identical throughout all of my worksheets) to the main "Overview" list.
Where it gets a little complicated is that I need to design the code so that my colleagues can, for instance, add/remove a situation/instance to any one of the 4 "info. lists" and then be able to see this addition automatically and immediately reflected on the "Overview" spreadsheet. Alternatively, I wouldn't be opposed to requiring the user to click an "Update Overview Sheet" button that would be assigned to the Macro that would accomplish the updating/transposing of the data, if it would be necessary.
I should mention that I am using Excel 2003. I have some prior programming knowledge with regards to PHP, ActionScript, HTML, etc., although to be honest it was more of a personal hobby and I haven't been programming for a while. I have next-to-no knowledge of VBA and Macros, but I am a quick learner and given my background of programming I do not think that learning another language would be exceptionally difficult.
If you need me to clarify anything that I have said please do not hesitate to ask.
Thank-you in advance for your help,
Scott
Last edited: