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
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!
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:
- Rebuild a split table!!sos
- How to delete part of a table in word - Guide
- School time table software free download full version - Download - Organisation and teamwork
- Ascii table c++ - Guide
- Html table fit to screen - Guide
- Back alley table - Download - Adult games
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 20, 2010 at 09:26 PM
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 20, 2010 at 10:22 PM
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
D2
=VLOOKUP(B2,F:I,2,FALSE)
E2
=VLOOKUP(B2,F:I,3,FALSE)
and drag them down
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!
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 21, 2010 at 05:25 AM
Jun 21, 2010 at 05:25 AM
could you post book and macro
Jun 20, 2010 at 09:42 PM
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.