To move Data rows to columns against one cell so can write separate SQL insert statments

Does this help?

Please Login or Register  to view this content.

Please comply with Forum Rule No. 3 - when posting. Looks like you have a working solution so comply with Forum Rule No. 9 as well:


9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

In my code I used the x variable to move down rows, and the i variable to move accross the Columns for each row. Then I was able to identify cells which were not blank and added a row beneath the working row. I used the rcell range variable to delete empty cells. You can pretty much pick up any VBA book, search the Forums such as this one or Google to advance your knowledge of how the variables work. Your code looks good, it just uses a different approach.

Yes your posts are good and have been helpfull, I feel I can learn from the code you gave me to do things more efficiently as your code is much faster than mine took to run.

The excel pratique site did say using arrays was fast?

Also you did'nt have to do any math in your like mine I had to come up with a formula for the series k = (8x) - 14.
If anyone wants the workings let me know and I'll post that here too.