Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macros within Excel
Is it possible to do a macro to update information between the following
situation. 1 - Journal Spreadsheet - same every week - needs to be updated in cells J2, J5, J8, etc. - every 3rd cell with information from spreadsheet 2. 2 - Payroll Spreadsheet - different every week - information in column H - cells H13, H14, H15 update cells in spreadsheet 1 - i.e. H13 to J2, H14 to J5, H15 to J8, etc. When the new payroll spreadsheet (spreadsheet 3) comes into play, it has a different name because of the date i.e. Payroll 2-15-08 - my macro only works from Spreadsheet 1 to Spreadsheet 2 - when Spreadsheet 3 comes into play - is there a way to do a macro to use this new information to go into Spreadsheet 1 - the Journal? Can this be done when it has a new name (different date)? I know about the + and = signs to update/change information from one spreadsheet to another - that is how I wrote my first macro. The cells we need to use for the upated information are in the same location every week. Spreadsheet 3 creates the problem.... Or is there a better way? Thanks for any input! -- Coni |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
Excel Macros | Excel Discussion (Misc queries) | |||
help with excel (maybe macros) | Excel Worksheet Functions |