Previous Topic Next Topic

Rebuild a split table!!sos

Closed
abcde - Jun 20, 2010 at 09:09 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 21, 2010 at 05:25 AM
Hello,

I need help on constructing a table.
Basically, i need to add in data from column H,I,J,K into B,C,D,E,F. Data in Column B & H are identical ( and in ascending order already) and i have to match up the data to give a complete table. ( the table is now split into 2 parts)
The problem is that data in column B are repeated. So i need a script that can help me to automaically fit the data in H,I,J,K to B,C,D,E,F (with a single button)
Could anyone help?Thanks!
Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 20, 2010 at 09:26 PM
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0
abcde
Jun 20, 2010 at 09:42 PM
https://authentification.site/files/23058842/abc.xls this is the link. Thank you.
I would like to put the the group of data into one based on the category "Car". The problem is that some of the data are repeated.
Thanks.
0
Answer 2 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 20, 2010 at 10:22 PM
Based on your sample book, you can put this in cell

D2
=VLOOKUP(B2,F:I,2,FALSE)

E2
=VLOOKUP(B2,F:I,3,FALSE)

and drag them down
0
abcde
Jun 20, 2010 at 10:57 PM
THANK YOU VERY VERY MUCH!!
0
abcde
Jun 21, 2010 at 03:08 AM
Thanks. I tried the code you entered and it worked perfectly. However, as to get the code, i record the steps using MACRO and paste them into the VBA platform. (to use a single button to build the table) However, everytime the data on the top left corner could not be shown and the formula for that box went wrong. Yet,The rest of the data are correct...... how could i fix it??THANKS AGAIN!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 21, 2010 at 05:25 AM
could you post book and macro
0