1 reply
by databaseben Accepted solution
In spite of the description being enigmatic, I think you may need to evolve into database technology. Fortunately, Excel and MSAccess handshake well. However, you can adapt the following database methodology to your Excel system. But it will be tricky. The trick is to utilize "keys" and create 2 separate tables. The data on the left side will have "keys", aka primary keys or account numbers and is stored in the primary table, ie your data warehouse. The data on the right should be entered into a separate table but have / use the "keys" that will link them to the primary table. Then when they are merged, you will achieve the effect you seek. Again, i really cant see what you have. But I am sure that 1) keys need to be used to your differing data types together. And 2) you will need at least two tables, ie a) primary/the archive from data warehouse and b) secondary/an input table. Imo, it may be time to evolve into database technology, when managing the data in Excel becomes limiting. In database's, you would have an input form for the data on the right. Then with some fancy coding, the report will be produced by merging the primary table with the secondary table, which occurs because the keys link the data together.
~dbben
This discussion is closed to new replies.
Trending Microsoft posts
Sort by Trending