Hi,
Im trying to match the size of two tables in different sheets using one of them as a parent. So that the size(range of rows) of table1 = that of table2. Table2 will get data input regularly, weekly or daily. Also, some of the columns will be repeated on both tables, but not all, so the number of columns will be different.
I'm not using VBA and would rather avoid it, unless extremely necessary.
Here is an example.
ExampleMatchingTables.xlsx
Cheers,
Dan
Last edited by kiwinho; 08-28-2012 at 02:15 PM. Reason: Solved Partially
Please post an example
Click on star (*) below if this helps
I added a file.
Cheers
I added this formula and copied across and down:
=IF(Sheet2!A3="","",Sheet2!A3)
I set the filter to non-blanks
See attached
But how do I set the size of table1 to match table2? Here the size of table1 is already set, and I don't know how long table2 will get.
You could make Table 1 very large but set the filter to non-blank values.
If you did, it wouldn't make any difference how big Table 2 got as long as it didn't exceed Table 1 and if it did you could make Table 1 bigger.
The key is to set the filter to non-blank values. You wouldn't see the blank rows
Otherwise you could do this with a macro but this method is much easier
Oh ok, and do I have to reapply the filters constantly or is there a way of doing it automatic?
No you do not need to reapply the filter once the file is saved
It worked! :D However, I realized that I can't really rely on the other user to adjust this. Can you help me with the macro? or maybe tell me where I should go?
Cheers
This is a non-macro solution and if set correctly does not need any additional adjustment by the user
=======
Others can help with a macro.
Im having troubles then. I applied the filter, but when I add data to table2 in order for them to showup on table1, I have to go to table1, and in the "DATA" tab, where the filter options are, I have to press reapply, and then it updates. Do I have to change an option?
Thanks a lot.
Check to make sure you have Calculations set to Automatic not Manual.
If Calculations are set properly, you should not need to do anything with the filtered list
I still have to press "reapply". Could it be due to the difference in Excel version? Im on 2010.
Don't know.
======
Others could help with a macro solution. That may help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks