software

I have a spreadsheet in sheet 1, cells A1 to L1 show months of the year. In
rows A2 to L50 there are numbers.

In Sheet 2 I want to create a sheet whereby the data for the sheet 1 table
can be inputted, amended, deleted etc.

In Sheet 2, cell A1, I input the month I want to adjust e.g 'Jan 2005'. What
i'd like to happen is the table in sheet 2 to become the January column from
Sheet 1 showing the data in that column in Sheet 1 and allow me to edit it
and change the figures. This should then update the info back in Sheet 1. Is
this possible without using pivot tables?

PLease let me know if you need me to explain further what it is I'm trying
to achieve.

Thanks in advance

Regards

Rich

Hi Rich

Pulling the data from Sheet1 is relatively straight forward.
Amending it on Sheet2 is no problem, but there is no way that the data
can be written back to Sheet1 without either
1 You copying the Data and Paste Specialgt;Values back to Sheet1
2 Some VBA code to carry out the task.

--
Regards

Roger Govierquot;Rich Hayesquot; gt; wrote in message
...
gt;I have a spreadsheet in sheet 1, cells A1 to L1 show months of the
gt;year. In
gt; rows A2 to L50 there are numbers.
gt;
gt; In Sheet 2 I want to create a sheet whereby the data for the sheet 1
gt; table
gt; can be inputted, amended, deleted etc.
gt;
gt; In Sheet 2, cell A1, I input the month I want to adjust e.g 'Jan
gt; 2005'. What
gt; i'd like to happen is the table in sheet 2 to become the January
gt; column from
gt; Sheet 1 showing the data in that column in Sheet 1 and allow me to
gt; edit it
gt; and change the figures. This should then update the info back in Sheet
gt; 1. Is
gt; this possible without using pivot tables?
gt;
gt; PLease let me know if you need me to explain further what it is I'm
gt; trying
gt; to achieve.
gt;
gt; Thanks in advance
gt;
gt; Regards
gt;
gt; Rich