Help with Macro Loop

[mjuarez1]

Hello,

I am attempting to write a macro loop that essentially adds 5 to each number in the previous iteration for a series of operations. They are as follows:

Please Login or Register  to view this content.

So the next iteration would be:

Please Login or Register  to view this content.

and so on.....
Is there just a simple way to loop this??? I have to do this set of operations many times and going in and changing each number defeats the purpose of the macro. Any help greatly appreciated. Thank you!!!

[mehmetcik]

Welcome

Unfortunately nobody can help you until you comply with rule 3.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[walruseggman]

I can't figure out your pattern. Can you post like the math between each cut/paste, please?

There's a simple solution including a For loop. Moreover, you selecting and activating is unnecessary.

This:

Please Login or Register  to view this content.

Can be this:

Please Login or Register  to view this content.

And this:

Please Login or Register  to view this content.

Can be this:

Please Login or Register  to view this content.

[mjuarez1]

Thanks for replying!

The code I have is just the macro I recorded using the keyboard and mouse (hence all the unnecessary stuff).

As far as the math goes the pattern is a tad confusing but I should have explained that basically what I am trying to do is take a data sheet with thousands of rows and 5 columns (the first row starts at 8 because there is header stuff above) and reorganize it into one with 8 columns, but they must be in the same order. So what I did was record myself doing it by hand.

Hope I'm being clear, really appreciate the help.

[alansidman]

reorganize it into one with 8 columns,

Explain the process in simple English. Be sure to explain the criteria in each case as if this was to be done manually. Once we understand the desired process we can give you a simplified macro to do this.

[mehmetcik]

Please Login or Register  to view this content.

[mjuarez1]

Sorry for the confusion. To better clarify, I have attached a file here and to the original post. On Sheet1 is an example of what I would like to alter using the macro. Because the information is sensitive and for simplicity's sake, I have deleted a significant amount of rows, though in the actual file there are thousands. The asterisks are just placeholders and do not need to be altered in any way. On sheet2 is the result I am looking for. Notice how the order of the data is preserved while the number of columns has gone from 5 to 8. I did this all by hand.

Hope that clears things up, thank you all for your help.

[mjuarez1]

mehmetcik I altered your code a bit and got it to work!!! Thank you x10000000000.

Please Login or Register  to view this content.