Automatically updating an agenda

[ellimist14]

Okay so first of all I know this is a needlessly complicated solution. But my boss is a little demanding and wants what he wants.

Anyway we have a weekly executive meeting and each member of senior management brings an agenda. Each agenda has old business (we'll call OB) and new business (NB) on it. I have to figure out a way to write a macro that updates last week's agenda automatically so he can inoutthis week's new business.

So last week's NB gets moved to this week's OB, but it can't replace last week's OB, it just needs to add to it. I hope my question makes sense, if it doesn't I can clarify if needed.

 

[ellimist14]

My main problem is that I have to keep the old data. I know how to write a macros to copy certain cells and paste to other certin cells. But what I need is copy from certain cells then paste at the bottom of the document, wherever it may be.

 

[codeliftsleep]

This is a simple string concatenation issue

public sub UpdateInfo()
   Dim oldData as string
   Dim newData as string

   oldData = Sheets("mySheet").Range("B5").Value 'copy the old Data
   newData = Sheets("mySheet").Range("C5").Value 'copy the new Data

   oldData  = oldData & vbCrLf & newData 'concatenate the old and new data, starting on a new line with the new data  
   Sheets("mySheet").Range("B5").Value = oldData 'write the concatenated data back to the cell
end sub

Then you might need to clear the contents of the new business cell depending on your needs---ie, you clear the cell so that its blank so they can enter in business for the next week.

You can also run this code over a range/loop to however many rows of data you have

 

[oldbrewer]

Agenda items usually generate one or more actions with target completion dates. So one agenda item is always progress of actions. Each meeting will generate more actions, and close out some old actions. The action list thus drives the meeting. Agreed actions are merely added to the list. Conditional formatting can apply red, orange and green coloring to the actions to make things more visible. A dynamic pie chart with red , orange and green segments provides an executive summary. Another pie chart can have open actions that are "on time", "close to overdue" and "overdue"...... Separate pie charts for different "departments" may be useful too. Happy to assist with this, but your post 1 is unclear, you can't have different agendas, but each senior manager can put items on the agenda.

 

[ellimist14]

This is a simple string concatenation issue

public sub UpdateInfo()
   Dim oldData as string
   Dim newData as string

   oldData = Sheets("mySheet").Range("B5").Value 'copy the old Data
   newData = Sheets("mySheet").Range("C5").Value 'copy the new Data

   oldData  = oldData & vbCrLf & newData 'concatenate the old and new data, starting on a new line with the new data  
   Sheets("mySheet").Range("B5").Value = oldData 'write the concatenated data back to the cell
end sub

Then you might need to clear the contents of the new business cell depending on your needs---ie, you clear the cell so that its blank so they can enter in business for the next week.

You can also run this code over a range/loop to however many rows of data you have

It gave me an error.

Compile error:

Invalid outside procedure

Sorry. I really don't know VB at all but I do understand computer logic pretty well.