+ Reply to Thread
Results 1 to 2 of 2

Updating tables!

  1. #1
    Rich Hayes
    Guest

    Updating tables!

    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

  2. #2
    Roger Govier
    Guest

    Re: Updating tables!

    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 Special>Values back to Sheet1
    2 Some VBA code to carry out the task.

    --
    Regards

    Roger Govier


    "Rich Hayes" <RichHayes@discussions.microsoft.com> wrote in message
    news:03D24EF3-BF12-4204-AA8F-73AA4A8882E0@microsoft.com...
    >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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1