multiple cell mapping

  1. K

    Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically have three tables. The first two tables contains rates based

    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...
  2. C

    Excel Workbook Question

    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...
  3. D

    Multiple Cell Selection using drop-down

    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...
  4. D

    Multiple data validation across multiple fields

    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...
  5. S

    Mapping XML elements to multiple cells

    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...
  6. S

    XML mapping to multiple cells

    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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top