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!

Rebuild a split table!!sos
School time table software free download full version - Download - Organisation and teamwork
How to delete a row in a table in word - Guide
Ascii table c++ - Guide
Html table fit to screen - Guide
Linux split file into n parts - Guide

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

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.

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

abcde
Jun 20, 2010 at 10:57 PM

THANK YOU VERY VERY MUCH!!

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!

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

Similar discussions

Cropping video in Daum PotPlayer

Similar discussions

Subscribe To Our Newsletter!