I have a number of spreadsheets which record data on monthly worksheets. For each of these, I have a “YTD” worksheet which sums all monthly data for the year to date.
I have another spreadsheet which is used for monthly management reporting purposes. Currently, the user enters manually the monthly data from the monthly tab of the various spreadsheets.
Is there any way of getting the monthly management reporting spreadsheet to selectively get the relevant data from the appropriate monthly worksheets by, say, specifying the month in a separate field. I have looked at the nested IF function, but can’t see any way of using it.
Also, what about doing a similar thing between Excel and a Word table? Is that do-able?
