hofmeister
New Member
- Joined
- Jul 18, 2007
- Messages
- 4
new to the forum and looking for some help,
I am trying to automate a Register to produce a summary list from a set of tabs (say 7) as follows:
i want the workbook to run a macro in the background and only activate when say i have filled out a row with data from columns A-G in one of the 7 respective tabes (the tabs can have x number of rows that i will be manually updating). This macro will recognise that i have filled out the row in the particular tab and run.
What i want the macro to complete: I want the macro to take this latest manually input data to a summary tab where it should find the last populated row and place the information one below that i.e. the next available empty row. (If possible would it work to get the macro to place the data to the same title heading as from the tab where the data is manually input i.e. the summary tab might have more columns then the tabs i manually input the data to.
I hope this makes sense and can be done. Any help would be much appreciated
I am trying to automate a Register to produce a summary list from a set of tabs (say 7) as follows:
i want the workbook to run a macro in the background and only activate when say i have filled out a row with data from columns A-G in one of the 7 respective tabes (the tabs can have x number of rows that i will be manually updating). This macro will recognise that i have filled out the row in the particular tab and run.
What i want the macro to complete: I want the macro to take this latest manually input data to a summary tab where it should find the last populated row and place the information one below that i.e. the next available empty row. (If possible would it work to get the macro to place the data to the same title heading as from the tab where the data is manually input i.e. the summary tab might have more columns then the tabs i manually input the data to.
I hope this makes sense and can be done. Any help would be much appreciated