[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

update sub table into master table

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
route217
Asked:
route217
  • 2
  • 2
1 Solution
 
theo kouwenhovenCommented:
Question is not clear enough, Where is the master table situated, can you supply us an example?
0
 
route217Author Commented:
Master table is in worksheet stay...same workbook as sheet 2..

Apologies murphey2..
0
 
theo kouwenhovenCommented:
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
 
route217Author Commented:
Agreed
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now