move cell data

  1. S

    Move dataset to new column when descriptor appears

    Hi, I'm trying to move a dataset into a new set of columns every time a descriptor appears. More specifically, if you look at linked images, I would like to move the corresponding dataset to new columns every time the word "particle" appears. Linked image #1 ...
  2. C

    Move Row to Bottom based on Cell Value

    Hi! New here and trying to learn some more complicated Excel tools. I have a spreadsheet where I want entire rows to drop down to the bottom when the value of a cell is greater than todays date. The cells of interest would be starting at G17 on. Any help would be amazing!
  3. S

    Move Data across worksheets based on cell input

    Hi, Can some excel genius help me out? I have multiple worksheets, lets say Sheet1 to Sheet 10 Depending on the Value in Column A, the whole row should be moved to the first empty row in the respective sheet. E.g: Value A --> Sheet 1 Value B --> Sheet 2 Value C --> Sheet 3 ….. However...
  4. J

    VBA move character to next column

    I want to write a code that If column A contains REG then move it over to column B and remove it from A. For example before a1 b1 tsf-REG after a1 b1 tsf REG How can I write code for this kind of purpose?
  5. J

    move cells where data on top of column.

    Hi guys, I am trying to move cells on the Product ID cells. <tbody> HEIN4 MC Product ID Prdouct Group 426 3 59 3 68 3 78 3 72 3 </tbody> Here is the example of data and I would like to move HEIN4 move down 5 and go left 2. Then Move MC 3 down and...
  6. R

    Moving records from worksheet to worksheet

    Hi, I have a list of people in one worksheet with various information about them. I have a column that you can either select yes or no for. I would like for when you select yes, that person and their information gets transfered to a new worksheet. Is there a way to do this? Any help will be...
  7. Y

    Move Contents of Multiple Columns Recursively

    Hello everyone, My problem looks simple on paper, but I have no idea how to get a macro to do what I want it to do. Right now, I have it to the point where it will move the entire contents of a single row into column A, but I need it to move the contents of three columns, D, E, and F, row by...
  8. E

    Help with building macro to create new rows and copy and paste cell content into new rows

    Hello, I have been manually doing a process all day long and I want a macro that allows me to highlight a row and do the actions automatically. Can someone on the board take a look at this and help me make a macro? The column looks like this originally: <tbody> Serial Date Title Name A Name B...
  9. B

    Excel macro to move columns to 1 row after each other

    I was hoping someone could help me write or find a macro that would take two columns and move it to column A under the previous data and repeat for all columns. Basically user information is located in pairs of columns (typeofvalue, value). So column A and B are for user1, column C and D are...
  10. H

    Using Dates to Move Completed Projects to Another Sheet

    Hi! I've tried for a couple hours to figure this one out on my own and just can't seem to get the right combination going. I need a macro that will look down a column of dates (and blank spaces for items that are not yet completed) and take out the ones that are older than a week and put them...
  11. E

    VBA Query - Can you point me in the right direction please

    Hi all, I am trying to get my head around how to start coding the following spreadsheet presented below in excel 2013. If someone could point me in the right direction as to what to look at or breakdown a set of tasks for me to carry out to complete the VBA code I would be much obliged. I have...
  12. 1

    How to move data from one cell into a different column but have the associated data attached follow.

    <colgroup><col><col><col><col></colgroup><tbody> Smith Jen Breakout_Session_1 I can read with my eyes smith Jen Breakout_Session_2 Wedo smith Jen Breakout_Session_3 App Safari Black Kay Breakout_Session_1 Multimodal Magic Black Kay Breakout_Session_2 Digital Pets Black Kay...

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