asked on Synchronizing values in columns
this is an Excel Question.
Column A Column B Column C Column D Column E
1314579 1314579 Alpha xx yy
1314579 1314579 Beta xx yy
1314579 1314579 Gama xx yy
1314579 1314579 Delta xx yy
1314577 1314577 Alpha xx yy
1314577 1314577 Beta xx yy
1314566 1314566 Camp xx yy
1314588 1314588 Alpha xx yy
1314588 1314588 Beta xx yy
1314588 1314588 Gama xx yy
---#######################
Upon the push of a button, on the excel sheet, arrange the above as follows
10 rows get reduces to 4 rows like below.
Column A Column B Column C Column D Column E
1314579 1314579 Alpha/Beta/Gama/Delta xx yy
1314577 1314577 Alpha/Beta xx yy
1314566 1314566 Camp xx yy
1314588 1314588 Alpha/Beta/Gama xx yy
Column A Column B Column C Column D Column E
1314579 1314579 Alpha xx yy
1314579 1314579 Beta xx yy
1314579 1314579 Gama xx yy
1314579 1314579 Delta xx yy
1314577 1314577 Alpha xx yy
1314577 1314577 Beta xx yy
1314566 1314566 Camp xx yy
1314588 1314588 Alpha xx yy
1314588 1314588 Beta xx yy
1314588 1314588 Gama xx yy
---#######################
Upon the push of a button, on the excel sheet, arrange the above as follows
10 rows get reduces to 4 rows like below.
Column A Column B Column C Column D Column E
1314579 1314579 Alpha/Beta/Gama/Delta xx yy
1314577 1314577 Alpha/Beta xx yy
1314566 1314566 Camp xx yy
1314588 1314588 Alpha/Beta/Gama xx yy
Microsoft OfficeMicrosoft Excel
Last Comment
Martin Liss
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Martin, Thanks. That worked.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Martin, Just a small change. Put the result in sheet 2 and keep the sheet 1 as is. I mean, when we press the "consolidate" button in sheet 1, the result should shows up in Sheet 2 keeping the original in sheet 1.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Very helpful. I will close the question. Thanks Martin.
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange Most Valuable Expert (MVE) 2015, 2017
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Experts Exchange Top Expert VBA (current)
ASKER
Hi Martin, You are indeed a very learned person. I am delving to VBA for Applications in support of Excel and Access. Can you suggest a good book on VBA which has examples and code that can be downloaded instead of typing it.
Thanks.
Kamal
Thanks.
Kamal
I don't have any actual advice about that since I'm basically a self-taught programmer and the last language I learned from a book was BASIC back in the 70's. It was in pre-web dark-ages days so it was an actual book:) I do know however that if you search for VBA tutorial that you'll get a lot of hits. If you run into things you don't understand I'll be happy to answer a couple of questions here and/or you can ask new questions and a lot of us will be happy to help.