| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy workbook and formulas to read to the present month
Hi
Hope some-one can assist. I have a workbook for stock control of various items PER MONTH. It consists of a 3 worksheets (stock control, costings and summary) and is named per month, example SEPTEMBER. Costings and summary read from the stock control worksheet.. If I re-save the entire WORKBOOK for a new month, and call it October, the costings and summary sheets still read values from Sep! Is there any way i can save it each month and up-date the values to read from the present month Stock Control worksheet. In particular can i do this without a Macro as I am pretty useless with Macros. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell to return present month | Excel Discussion (Misc queries) | |||
| reset a workbook each month saving a copy and using totals to rest | Excel Discussion (Misc queries) | |||
| how to copy formulas across a 1-31 day file and month end total | Excel Discussion (Misc queries) | |||
| calculating month of present date | Excel Discussion (Misc queries) | |||
| Need Help to Prevent Copy Function Use in a Read-Only Workbook | Excel Worksheet Functions | |||
Linear Mode
