Advanced excel problem- beyond my knowledge! Let me know if this is possible.

E

ExcelHelp123456

New Member
Joined
May 16, 2017
Messages
9
Hey Ya'll,

Just need some help with an excel issue i'm having that's a bit more advanced that I know how to do.. Is it possible to move these descriptions to the lines that correspond with above and to the left? Hopefully this makes more sense with the picture below. Thanks!


EXCEL_spredsheet.PNG
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Sort by date Sort by votes
Might be over kill (probably easier way), but I would probably save the file with another name and then vlookup from that file to fill in the above columns. Would write the formula something like =if(A21=A20, "",vlookup(a21,.......)). This way you only get the value returned on the first line. After that I would Copy - Paste Special Values to get rid of the formulas. Hope this helps.
 
Upvote 0
SG2001 said:
Might be over kill (probably easier way), but I would probably save the file with another name and then vlookup from that file to fill in the above columns. Would write the formula something like =if(A21=A20, "",vlookup(a21,.......)). This way you only get the value returned on the first line. After that I would Copy - Paste Special Values to get rid of the formulas. Hope this helps.
Click to expand...


Thanks for the reply.. I think this all may be beyond my abilities. This spreadsheet is thousands and thousands of lines long and I have several of them. So, was just hoping to find a more efficient than just copy and pasting the whole way down but I may have to just do that.

Thanks,
Kris
 
Upvote 0
I would like to help but you have not explained in words what you want. You have only provided an image that I can hardly see or understand.
 
Upvote 0
Hi My Aswer Is This

Apologies, so what I need to have happen is you'll see in column A several different groupings. for instance "fanning" is one and it changes as you move down the list to a new grouping once all the sizes have been listed. For each grouping in that column there is corresponding data about that grouping in the columns following to the right (circled in blue). This blue circled data basically needs to be at the start of each grouping (such as fanning at row 33) horizontally- right now it's arbitrarily in a random spot within that grouping. This is for 1000's of skus so it takes forever to move this blue circled information to the start of each grouping. Hopefully this helps! Thanks in advance!


My Aswer Is This said:
I would like to help but you have not explained in words what you want. You have only provided an image that I can hardly see or understand.
Click to expand...
 
Upvote 0
Why did you not post an image of what you want with the values you want in the cells.
Instead of drawing lines showing what you want.

And why do you have "Fanning" for example in column "B" I assume this is column "B" your image does not really indicate what columns these are?

And why do you have more data after "Fanning" not sure how you come up with those values and then you have "Color" circled in several other places with no explanation what "Color" means.
 
Upvote 0
A mixture of incompetence and ignorance I suppose. Let me try again.


My Aswer Is This said:
Why did you not post an image of what you want with the values you want in the cells.
Instead of drawing lines showing what you want.

And why do you have "Fanning" for example in column "B" I assume this is column "B" your image does not really indicate what columns these are?

And why do you have more data after "Fanning" not sure how you come up with those values and then you have "Color" circled in several other places with no explanation what "Color" means.
Click to expand...
 
Upvote 0
So Picture 1 is how I receive the data exported out of an internet platform and I need to reorg it to look like image 2 so I can reupload it and the item details show up correctly on the website.

Basically b6-h6 + j6 need to be moved to b2-h6 & j2 respectively. b16-h16 + j16 to b12-h12 + j12. And so on- Hope that makes sense...




2.PNG






1.PNG
 
Upvote 0
Thanks for providing these images they are much better.
It appears as if your wanting to delete some rows but your saying only certain portions of the row.

You said:

b6-h6 + j6

Which means delete Only part of the row.

I would think that would throw off all the data in the other columns

But I keep hoping someone else will jump in and help me as I admit sometimes it hard for me to understand things.

Like why are we only moving up certain columns of data and not move up or actually we will be deleting the data Why not the entire row?
 
Upvote 0
Maybe this will do the trick....UNTESTED....I don't have Excel at the moment

Code: 
Sub MM1()
 Dim lr As Long, r As Long
 lr = Cells(Rows.Count, "A").End(xlUp).Row
 For r = 2 To lr
    If Cells(r, 1) = Cells(r + 1, 1) Then
        Range(Cells(r, 2), Cells(r, 8)).Copy Cells(r + 1, 2)
        Cells(r, 10).Copy Cells(r + 1, 10)
    End If
Next r
End Sub

To insert this code press ALT + F11
On the menu bar>>Insert>>Module
Paste the above code in the RH window where the cursor is flashing>>close that window


To run the code....Press ALT+F8>>select the code from the list>> press RUN
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

Ramballah
  • Question
Need a formula that counts the shifts and gives me a total
Replies
2
Views
222
bobaol
B
M
  • Question
Formula to populate the next available cell in a column using data populated in another cell.
Replies
4
Views
337
Marshkevuk
M
P
  • Solved
VBYes/No Responses
Replies
5
Views
343
Pacman52
P
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
M
  • Question
Stop my VBA Userform objects from moving when switching screens
Replies
3
Views
996
Micron
M

Forum statistics

Threads
1,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top