Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2020, 03:22 AM
DIMI DIMI is offline Group data on a second sheet Windows 7 32bit Group data on a second sheet Office 2007
Advanced Beginner
Group data on a second sheet
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default 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.
Attached Files
File Type: xlsx EXAMPLE.xlsx (14.4 KB, 14 views)
Reply With Quote
  #2  
Old 10-03-2020, 04:46 AM
Purfleet Purfleet is offline Group data on a second sheet Windows 10 Group data on a second sheet Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Why are only some of the numbers in the example populated?

As a quick fix
  • Under the AB in cell A3 type in =IF($G3="","",A2)
  • Then drag to the right so you get AB and APPLE repeated
  • Copy A3 by pressing ctrl C
  • High light column A & B then press ctrl G
  • Click special & then blanks and OK
  • Then ctrl V
  • All the code & products will be populated
  • Select the whole grid and sort by Code A-Z
  • Delete blank rows
  • Then just reference the correct column (so sheet2 A3 will be =SHEET1!C2 etc etc)
Takes about 30 seconds once you have done it a few times
Reply With Quote
  #3  
Old 10-03-2020, 11:43 AM
DIMI DIMI is offline Group data on a second sheet Windows 7 32bit Group data on a second sheet Office 2007
Advanced Beginner
Group data on a second sheet
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default

Thanks a lot for this but there is any macro to do it ?
Reply With Quote
  #4  
Old 10-03-2020, 12:20 PM
Purfleet Purfleet is offline Group data on a second sheet Windows 10 Group data on a second sheet Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
Reply With Quote
  #5  
Old 10-03-2020, 11:56 PM
DIMI DIMI is offline Group data on a second sheet Windows 7 32bit Group data on a second sheet Office 2007
Advanced Beginner
Group data on a second sheet
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 10-05-2020, 11:25 AM
DIMI DIMI is offline Group data on a second sheet Windows 7 32bit Group data on a second sheet Office 2007
Advanced Beginner
Group data on a second sheet
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default

Please guys to help me
Reply With Quote
  #7  
Old 10-05-2020, 11:34 AM
Purfleet Purfleet is offline Group data on a second sheet Windows 10 Group data on a second sheet Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Why does it need to be a Macro? In your OP you state
Quote:
I would like some help probably only with a macro unless there is an easy way.
Well there is an easy way as shownI think you are making it harder than it needs to be, the process i gave you above works and is quick. A macro will take time.

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.
Reply With Quote
  #8  
Old 10-11-2020, 03:04 AM
DIMI DIMI is offline Group data on a second sheet Windows 7 32bit Group data on a second sheet Office 2007
Advanced Beginner
Group data on a second sheet
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default

Good morning


Please somebody to help me


Thanks a lot !!!
Reply With Quote
  #9  
Old 10-11-2020, 05:07 AM
Purfleet Purfleet is offline Group data on a second sheet Windows 10 Group data on a second sheet Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Quote:
Originally Posted by DIMI View Post
Good morning


Please somebody to help me


Thanks a lot !!!
Did the above process not work?
Reply With Quote
  #10  
Old 10-11-2020, 12:18 PM
NoSparks NoSparks is offline Group data on a second sheet Windows 10 Group data on a second sheet Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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 ?
Reply With Quote
Reply

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
Group data on a second sheet 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
Group data on a second sheet Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Group data on a second sheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft