+ Reply to Thread
Results 1 to 2 of 2

Table amending by overwriting table?? what formula index/match

  1. #1
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    Excel 2013
    Posts
    123

    Table amending by overwriting table?? what formula index/match

    I have a requirement to look at a products sales-which I have in a table format product by week no.

    I want to collate my forecast ( tabled the same)

    Then while the exsitjng tables are viewed ( in a consolidation sheet-for example named result on the attached)

    I want to be able to overtype the new forecast.

    I can see how to present the data( using Index and Match)- but I cant figure out how to overtype the forecast and feed it back to the original forecast table.

    I thought I may use the camera feature to display the actual table (using a drop downlist to expose the product I wanted) then over typoe the camera view-I can use the exisiting formaulae to express the sales and forecasts onto a graph to calculate means etc?

    I have added some basic tables attachedtest sheet amended link.xlsx

  2. #2
    Forum Contributor
    Join Date
    10-25-2012
    Location
    london,england
    MS-Off Ver
    Excel 2013
    Posts
    123

    Re: Table amending by overwriting table?? what formula index/match

    So- maybe its unclear- how do i load back into a spreadsheet that Im looking at---???

    I selct the code-it gets displayed-I then have the option to amend- would this be a macro - rewriting ove rthe top of the original table

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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