Template

[Tathanboy]

I use quite a lot of data each month. I want to create either a Macro/style
format or whatever is suggested. From my main data sheet I need to create 10
further worksheets which show different performance data for the 10 different
variables I have in a particular column. The formatting should be the same.
Eg headers/footers/margins etc. I have used the style icons. is there a way i
can creatye a template so that all i need to do at the end of each month is
copy my data into a worksheet, press a button and the other worksheets will
be populated with the information. Or is Macro the only way to do it

 

[RobertVA]

I use quite a lot of data each month. I want to create either a Macro/style
format or whatever is suggested. From my main data sheet I need to create 10
further worksheets which show different performance data for the 10 different
variables I have in a particular column. The formatting should be the same.
Eg headers/footers/margins etc. I have used the style icons. is there a way i
can creatye a template so that all i need to do at the end of each month is
copy my data into a worksheet, press a button and the other worksheets will
be populated with the information. Or is Macro the only way to do it

Excel version?

Have you tried referencing cells on other worksheets within your
workbook in your formulas?

Simplest way:

Type an equals sign in your destination cell (lets say it's on Sheet1)

Use the tabs to switch to the worksheet with your source data

Click the cell containing your source data

You may continue to combine cell references to finish your formula. Fee
free to use math operators between cell references or include cell
references within parentheses (for functions or to control precedence).

Press the ENTER key when you're finished with your formula

You should end up with a formula resembling "='Data Entry'!A1+Sheet3!B3"

This procedure might work in other GUI based spreadsheet applications.


Please post again so we will know the extent to which this is helpful.