auto copy

[spmurphy]

I am trying to put an exported file from an accounting program into a excel table. I am having a problem with copying the posting month. The rows will be the variable. The posting moth will be column "B". I need the posting month to auto copy until they have an empty cell. What ever cell that copied that row will need to shift over five columns.


Current:

Account : 7100 Accounting expenses

1 / 2011

3 1121 1/12/2011 200.00 613300 RSC & Company 42750

200.00 0.00 Debit : 200.00 0.00

2 / 2011

3 1121 3/1/2011 500.00 613300 RSC & Company 42955

500.00 0.00 Debit : 500.00 0.00

3 / 2011

3 1121 4/5/2011 6,000.00 613300 RSC & Company 42982

6,000.00 0.00 Debit : 6,000.00 0.00

4 / 2011

3 1121 4/12/2011 900.00 613300 RSC & Company 43321

900.00 0.00 Debit : 900.00 0.00

5 / 2011

3 1121 5/19/2011 25,500.00 613300 RSC & Company 43617

3 1121 5/19/2011 6,000.00 613300 RSC & Company 43661

3 1221 5/26/2011 -6,000.00 613300 RSC & Company 43661C

25,500.00 0.00 Debit : 25,500.00 -4,000.00

10 / 2011

3 1121 10/27/2011 7,000.00 613300 RSC & Company 43905

7,000.00 0.00 Debit : 7,000.00 0.00

11 / 2011

3 1121 12/7/2011 400.00 153295 CBS RSC & INS 11162011

3 1121 12/7/2011 300.00 153295 CBS RSC & INS 44099

3 1121 12/7/2011 1,000.00 153295 CBS RSC & INS 44215

1,700.00 0.00 Debit : 1,700.00 0.00

12 / 2011

0 9221 4/27/2012 -41,900.00 Closing JV Journal Reference

-41,900.00 0.00 Debit : 0.00 -41,900.00

*** Account Total : 0.00

*** End Of Report ***


After:


1 1/12/2011 200.00 613300 RSC & Company 42750

2 3/1/2011 500.00 613300 RSC & Company 42955

3 4/5/2011 6,000.00 613300 RSC & Company 42982

4 4/12/2011 900.00 613300 RSC & Company 43321

5 5/19/2011 25,500.00 613300 RSC & Company 43617

5 5/19/2011 6,000.00 613300 RSC & Company 43661

5 5/26/2011 -6,000.00 613300 RSC & Company 43661C

10 10/27/2011 7,000.00 613300 RSC & Company 43905

11 12/7/2011 400.00 153295 CBS RSC & INS 11162011

11 12/7/2011 300.00 153295 CBS RSC & INS 44099

11 12/7/2011 1,000.00 153295 CBS RSC & INS 44215

12 4/27/2012 -41,900.00 Closing JV Journal Reference

 

[SirJB7]

Hi, spmurphy!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Consider uploading a sample file, it'd be very useful for those who read this and might be able to help you. Thank you.


Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!