#1
|
|||
|
|||
Group data on a second sheet
Good evening
I would like some help probably only with a macro unless there is an easy way. I have entered some data in sheet 1 (code, product, cartons, gross and net weight, size and number). I would like to group the data on sheet 2 based on the number and copy the rest of the data. I have also made an example in sheet3 which result I would like. Please for your help. Thank you. |
#2
|
|||
|
|||
Why are only some of the numbers in the example populated?
As a quick fix
|
#3
|
|||
|
|||
Thanks a lot for this but there is any macro to do it ?
|
#4
|
|||
|
|||
yes it can be done, but its a trade off between time taken to do the process vs the time to develop it.
This process is very quick and straight forward and unless you need to do it 100's of times i would say its not worth it. If you want to give it a go, feel free - i am happy to help if you can make a start Last edited by Purfleet; 10-03-2020 at 12:21 PM. Reason: Space |
#5
|
|||
|
|||
I have not any idea to make a macro.
Please help me. Thanks a lot. Like this : Sub PostToRegister() Set WS1 = Worksheets("SHEET1") Set WS2 = Worksheets("SHEET2") 'Figure out which row is the next row NextRow = WS2.Cells(Rows.Count, 1).End(xlUp).Row + 1 'Write the important values to Register 'Write the important values to Register WS2.Cells(NextRow, 1).Resize(1, 6).Value = Array(WS1.Range("C"), WS1.Range("D"), WS1.Range("E"), _ WS1.Range("F"), WS1.Range("G"), WS1.Range("E")) End Sub ***But i want to to copy and collected all the data from the same number together . Afterward to collected all the data from another number together . Finally the numbers i want to see the column F. |
#6
|
|||
|
|||
Please guys to help me
|
#7
|
|||
|
|||
Why does it need to be a Macro? In your OP you state
Quote:
I didnt notice that you wanted to group the data with the number at the end, so the last step needs to be to sort the table by number. |
#8
|
|||
|
|||
Good morning
Please somebody to help me Thanks a lot !!! |
#9
|
|||
|
|||
Did the above process not work?
|
#10
|
|||
|
|||
Why the fixed limit of 22 entries on SHEET2 when SHEET1 does not appear that it would have the same limit ?
Is it imperative the number order of column F be as in your EXAMPLE sheet or would an A->Z order be acceptable ? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet | mcronin | Excel | 1 | 05-09-2016 09:43 AM |
Can a Data Source be one sheet in a multi-sheet Workbook | nfotx | Mail Merge | 1 | 07-01-2015 12:55 AM |
Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
Help Coloring a cell in Sheet one if data is missing from another sheet | Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
From an XL sheet ,how to keep the group of columns which match with other XL sheet | Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |