Copy column sub-headings to inserted column via formula

**Geppstar** · 12-13-2013, 05:05 PM

I am looking for some help with the attached excel file. I'd like to be able to copy the files subtotal headings from column A into column B via a formula. The attachment is an excerpt of a trial balance that I'm working with. If I only had to do this once I would just copy and paste, but I just started a new job and every tiral balance that I'm going to be working with will be exported in the same format. The attachment contains additional information and an example of what I'd like the final product to look like. Any help is appreciated!

Thanks,

David

**daffodil11** · 12-13-2013, 05:36 PM

This formulas assumes 1000 rows or less per subtotal.

Plop this into B8 and copy down as far as needed.

=IF(AND(NOT(ISBLANK(A9)),ISNUMBER(C8)),INDEX(A8:A1000,MATCH("C"&"*",A8:A1000,0)),"")

Feel free to adjust the range to less rows.

Do not use absolute references (meaning that when the formula is copied down 30 rows, the formula in B29 will roll to:

=IF(AND(NOT(ISBLANK(A30)),ISNUMBER(C29)),INDEX(A29:A1021,MATCH("C"&"*",A29:A1021,0)),"")

Copy column sub-headings to inserted column via formula

LinkBack

Thread Tools

Rate This Thread

Display

Copy column sub-headings to inserted column via formula

Re: Copy column sub-headings to inserted column via formula

Thread Information

Users Browsing this Thread

Similar Threads

Create macro to copy data using column headings

Copy/Paste filtered data from one sheet to another with only matched column headings

copy column headings of cells with missing data into a single cell

[SOLVED] Copy Column headings to Rows

[SOLVED] copy excel worksheet into msword with row, column headings and gr.

Bookmarks

Bookmarks

Posting Permissions