multiple cell mapping

Hello! I have the following task/problem. I have to set a master file with 3 sheets. The Sheet1 (Prediction) contains data as hours from a month so 720 to 744 hours. The task is : 1. To add to the Sheet2 (Energy 15-min Prediction) the value from every single cell from Sheet1 range from B6:B725...

Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically need to merge three tables into one. The first two tables contains rates based on an issue age, and a fixed period of time. The only difference between them is the first table is for a "Band" class 1, the...

Hello everyone, I am stuck. I am trying to combine several different reports we fill out daily into one workbook with different pages for each report as opposed to seperate files for each report. My problem is these reports were created by someone that is no longer with us and one of the...

HELP ME PLEASE! My database is simple (employee name, category, hourly rate, overtime rate, reg hours worked, overtime hours worked). My problem is the employee list is huge and they all have different categories. I have the employee list set-up as a drop-down. I want to be able to drop-down...

HELP! I have a spreadsheet setup like a timesheet: Employee Name, Classification, Rate, etc. I setup the Employee Name field as a drop-down. Since there are numerous employees with different rates, I want to just select a name so that the other fields fill-in with the appropriate rates. Is...

Hello, I am trying to produce an Excel file filled with data from the XML file. Some of the cells need to have the same element data. However the Microsoft Excel is not allowing to map an XML element to more than one cells. Could somebody know of a way to achieve this result/ solution...

hi, I am trying to map an XML elements to multiple cells in a workbook and MS Excel is not allowing this. I would really appreciate if somebody can tell me of how to do the multiple cell mapping. Thanks, Antony