Question description:
This user has given permission to use the problem statement for this
blog.
I am trying to insert a row from sheet two into sheet one when data in column B changes I have 8 columns and about 500 rows. any suggestions
Solved by X. W. in 43 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/08/2018 - 01:17
Hi
Excelchat Expert
05/08/2018 - 01:17
Welcome to Got it Pro
Excelchat Expert
05/08/2018 - 01:17
Can you tell more about the requirement so that i can help you better
User
05/08/2018 - 01:19
I just need to add a header bar every time a value changes in column 2
Excelchat Expert
05/08/2018 - 01:19
Can you show me on the spreadhsset about the requirement
Excelchat Expert
05/08/2018 - 01:19
Let me see if this can be done through formulas
Excelchat Expert
05/08/2018 - 01:24
Are you there?
Excelchat Expert
05/08/2018 - 01:24
Can you please tell
User
05/08/2018 - 01:27
sorry had an important call
Excelchat Expert
05/08/2018 - 01:33
Please tell more about the requirement
User
05/08/2018 - 01:34
here is the sort of thing
[Uploaded an Excel file]
User
05/08/2018 - 01:36
I need to agg line 1 every time the data in column B changes
User
05/08/2018 - 01:36
I have row one saved on sheet 2 of the workbook
Excelchat Expert
05/08/2018 - 01:38
ok
Excelchat Expert
05/08/2018 - 01:38
give me a minute
User
05/08/2018 - 01:38
thanks you are a star
Excelchat Expert
05/08/2018 - 01:39
So how do you want to aggregate?
Excelchat Expert
05/08/2018 - 01:39
what do you want to actually show
User
05/08/2018 - 01:40
I just want to insert the data from sheet 2 row 1 A to H into sheet one everytime the station name changes
User
05/08/2018 - 01:41
so data in column b
Excelchat Expert
05/08/2018 - 01:42
Can you put data for sheet 2 also
Excelchat Expert
05/08/2018 - 01:42
I want to see how it changes and what is required
User
05/08/2018 - 01:43
here
[Uploaded an Excel file]
Excelchat Expert
05/08/2018 - 01:43
but you dont have any data in sheet 2
Excelchat Expert
05/08/2018 - 01:47
I am not getting enough replies from you..i hope this does not affect my rating
Excelchat Expert
05/08/2018 - 01:47
Please give good ratings and reviews when you end the session..it really helps
Excelchat Expert
05/08/2018 - 01:47
I want to help you in the best possible way
User
05/08/2018 - 01:48
sorry you are being great
User
05/08/2018 - 01:50
have modified all so what i am looking for is to insert the data from sheet 2 row 1 into sheet 1 when column B changes there is about 500 rows of data in the full sheet
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.