Solved

update sub table into master table

Posted on 2014-01-20
4
346 Views
Last Modified: 2014-01-20
Hi Experts excel 2007

I have a sub table in worksheet 2 column a2 and b2...a1 and b1 have header...
which I want to update into a master table worksheet stay...same data range....without altering the current records in the master table just updating with the new values from wrksht2...

All wotksheets same workbook.   What's the best way to update in master table
0
Comment
Question by:route217
  • 2
  • 2
4 Comments
 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 39794075
Question is not clear enough, Where is the master table situated, can you supply us an example?
0
 

Author Comment

by:route217
ID: 39794081
Master table is in worksheet stay...same workbook as sheet 2..

Apologies murphey2..
0
 
LVL 16

Accepted Solution

by:
theo kouwenhoven earned 500 total points
ID: 39794187
so the SubTable (column a2 and b2...) is a copy of the master table... in that case, you just type new info in the reqired cells, it's a copy so the master will not change or do I miss something?
0
 

Author Comment

by:route217
ID: 39794724
Agreed
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question