Home |
Search |
Today's Posts |
#1
|
|||
|
|||
same cell from multiple sheets into one column
I have many tabs that I want to copy information into a new sheet
within the same workbook. I need to Copy A5 into Column A, A10 into Column B, C3 into Column C. Column D needs to be a total, which is listed in Column H, but it in different cells, the cell above it always says Balance. Column E needs to be the last populated cell in the column that says balance. Headers should be A:Loan Number, B:Start date, C:End date, D:Original Balance, E:Current Balance. Is there a macro that can handle this?? If so, please help--my boss is breathing down my neck!! Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Value of last non-blank cell in a column | Excel Worksheet Functions | |||
One cell from several sheets to one column | Excel Discussion (Misc queries) | |||
Summing same cell/cells from multiple sheets | Excel Worksheet Functions | |||
VBA 'deleting row if a cell in column A is a zero. | Excel Worksheet Functions |