Finding and Copying 1 Rows Above

[Cubical]

Hey!

So I was wondering if I can get some help on making a marco that reads through the worksheet and finds a specific text, then coping that text into a specific column into the above row then copying that top row into another worksheet. Sounds a bit confusing? Any ideas?

Thanks!

[Leith Ross]

Hello Cubical,

A real life example would be a good first step. If you have a workbook, that would be best. If not then post a before and after example.

[Cubical]

I uploaded an example hopefully this helps.

Thanks!

[Leith Ross]

Hello Cubical,

Thanks for posting the file. I don't you could have explained the layout and have it made sense. Does the file id always follow the sheet id?

[Cubical]

Sorry about that. But yes, since the excel file is actually a dump file from another database some of the data is floating around in the wrong spot. The marco I wanted to create is to sort this file, and sort things into their proper headings. So the name of the person, would be moved up into the row with all the information, while the file ID is moved from the sheet ID, which is where its not suppose to be, into the file ID of the above row that is is under. As you can see in the example.

[Cubical]

So I have a file with a lot of information I don't need. From the example file you can see a description section in the before worksheet. I don't want that to be copied over to the after worksheet. I just want to somehow making a code to loop til the end of the file finding a the file ID, which has been misplace under the sheet ID. Then I want to copy the row above the found File ID and move it into the after worksheet. At this point also moving the File ID into the row just copied into its rightful field. Same with the name, it is 2 rows below its rightful row, I want to be able to copy that back into the row, when copying it over to the worksheet.

I hope its clears things up a bit? To put it in simple terms. I have a messy file, I want to sort out that file by leaving everything I don't need in the old worksheet, and moving everything into I want into a new worksheet. With everything in its original fields.

[Leith Ross]

Hello Cubical,

Provided the real data output matches the example, you should not have any problems. It is difficult to create a macro to recopy or reformat data based only on 2 examples. As experience has taught me, consistency in output files is rare. The macro has been added to the attached workbook.

Please Login or Register  to view this content.

[Cubical]

I should be able to work with this, thank you very much!