save column data to rows

[SvenGolster]

Hello and thx...how to do this ?
keep a running record in rows...
A---H I J K
1 4-4 8 2 6
2 8-5 6 1 4
3 2-8 3 2 5
4 6
5

6 5
7 6
8 1
9 4
10

11 8
12 3
13 2
14 5

[natefarm]

Sorry, I have no idea what you're trying to do there.

[alansidman]

Try this:

Please Login or Register  to view this content.

[SvenGolster]

Thnx Alan, Looks like you see what I was getting at.
Unfortunately, I don't know what to do with the code.
Will do some more research. thanx

[newdoverman]

This will put 0 at the end of each row where there are blanks every 5th cell

Please Login or Register  to view this content.

The result is:

	C	D	E	F	G
1	4	8	2	6	0
2	5	6	1	4	0
3	8	3	2	5	0

[newdoverman]

This will put 0 at the end of each row where there are blanks every 5th cell

Please Login or Register  to view this content.

The result is:

	C	D	E	F	G
1	4	8	2	6	0
2	5	6	1	4	0
3	8	3	2	5	0

If you drag the formula over only 4 columns and then down the result is:

	A	B	C	D	E	F
1	4		4	8	2	6
2	8		5	6	1	4
3	2		8	3	2	5
4	6
5
6	5
7	6
8	1
9	4
10
11	8
12	3
13	2
14	5

[alansidman]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[SvenGolster]

Alan...ty...did insert> Module that's as far as I got yesterday.....will follow the rest of the instructions.

[SvenGolster]

newdoverman...great piece of code there...I missed the part that was emailed to me so it only took me 6 hours to understand it all....lol
just what I needed ty

[newdoverman]

You're welcome. Thanks for the feedback.