Quick Macro Help

[JTSHOW]

Hey all I need some help. Just discovered macros and need to use one for a big file. I have a set of data like so:
[TABLE="width: 500"]
<tbody>[TR]
[TD]date[/TD]
[TD]time[/TD]
[TD]number[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]number[/TD]
[/TR]
</tbody>[/TABLE]
which has 25 numbers for each date/time. i need to copy and past, then transpose to this format on a separate sheet:
[TABLE="width: 500"]
<tbody>[TR]
[TD]date[/TD]
[TD]time[/TD]
[TD]number[/TD]
[TD]number[/TD]
[TD]number[/TD]
[TD]etc.[/TD]
[/TR]
[TR]
[TD]date2[/TD]
[TD]time2[/TD]
[TD]number[/TD]
[TD]number[/TD]
[TD]number[/TD]
[TD]etc[/TD]
[/TR]
</tbody>[/TABLE]

the data is thousands of rows long, so a macro would be much appreciated!!

 

[hiker95]

JTSHOW,

Welcome to the MrExcel forum.

What version of Excel are you using?

By what you posted we can not tell what cells, rows, columns your raw data is in.

So that we can get it right the first time:

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[JTSHOW]

I have to move data from several different sheets onto one, which makes things a bit complicated. I know how to edit macro code, just am unfamiliar with the excel side of the code. I am running Excel 2010, and am moving the time and date from columns A and B, 25 rows apart of one worksheet(i will be changing which one) to columns A and B on 'Template', one set per line. the numbers must be transposed from column G, rows 1-25, (then 26-30 and so on) to Template on the same row column C to AA. I will post screenshots here shortly.

 

[JTSHOW]

Raw Data
http://www.flickr.com/photos/thejtshow/8564292928/
Need in this form
http://www.flickr.com/photos/thejtshow/8563189481/

 

[hiker95]

JTSHOW,

You are posting pictures/graphics. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense.

To get it right the first time:

You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.


If you can not attach your workbook, then:

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.