worksheet consolidation

Hello Everyone, This is my First Thread in Mr.Excel :) I have bunch of Workbooks in One of the shared folder, and I am looping the (Summary) Sheet in all the workbooks to one main workbook, However my issue is, for some of the workbooks (Multiple sheets were selected) Need you help to...

I have a problem organizing my data into worksheets with consistent variables. I am looking at: |company name (A1)| Fund Name (B1)| Valuation (C1)|, however not all companies are in all quarters. Basically, the company name and fund need to be consistent over the 20 worksheets. Is there a way...

Hello everyone, I am an excel newbie that needs some serious help! I am using Excel 2010 on windows 7 PC. I work for a railroad and one of my coworkers gets data once a week about how many carloads we ship to a certain company. They save each week in its own worksheet so at the end of the year...

I am a new user of VBA and would appreciate your support. I have a data set for each of the following workbooks Labor Wages, Capital Expense, and Licensing Expense. -Each of these Workbooks have several projects (displayed horizontally) identified by the following characteristics: Project ID...

Hi, I am trying to consolidate monthly account information from several worksheets into a single summary worksheet. I defined names for the data in each worksheet (i.e. _BCC1, _BCC2, etc) and I created the following formula to work for the Jan column in my summary worksheet...