Search results for query: *

Such a beauty. Works a treat. Thanks a lot!

The copy and paste part is simple using macro recorder when selecting the data directly from "Work_Completed_" and subsequently the macro is generated for this. I do not have the skill to make excel read the range in "row data" rather than the rows physically selected in "Work_Completed_" Thanks,

I am exporting data from MS project into excel to make charts. The charts graphically monitor the project progress. The project is concerned with planning the build of a car. At the moment the data that is exported is not currently grouped into the main car/project areas, therefore my chart...

My row ranges look like this: 2:173 174:326 327:804 805:1260 1261:1162 1163:1634 1635:1722 1723:2172 2173:2307 2308:2329 2330:2468 2469:2558 2559:2929 2930:3032 3033:3135 3136:3500 Is this the right format? They start from C:20 down to C:36 in worksheet 2. Your help will be very much...

Apologies, I meant worksheet not workbook. The data is all contained within the same workbook. I want to select rows in worksheet 1, the range of rows is determined in worksheet2 and paste them into A1 worksheet 3. This will be repeated multiple times as there are multiple worksheets and...

Hello, I want to copy a range of rows from workbook 1 into workbook 2. The range of values I want to copy from workbook 1 into workbook 2 is calculated in workbook 3. My range is being displayed as: 2:173 How can I do this? Thanks!

@Skipvought This worked a treat: "You could also SELECT the column containing the fake dates. Data > Text to columns -- FIXED WIDTH NEXT UNCHECK all selection -- NEXT select MDY FINISH The fake dates become real DATE/TIME values. Use Custom Number Format as desired" I had to...

Hello, I want to copy a range of rows from workbook 1 into workbook 2. The range of values I want to copy from workbook 1 into workbook 2 is calculated in workbook 3. My range is being displayed as: 2:173 How can I do this? Thanks!

Hello, I am trying to export data from Project 2010 into Excel 2010 so that I can generate a chart of Planned tasks Vs. Time and Actual Start Tasks Vs. Time. I can therefore visually see where the project has moved away from the plan. I am exporting: Project Name Duration Start Date Finish...