Recent content by Garling_Beard

  1. G

    Creating duplicate rows based upon cell criteria

    Ok it is working as described but I have added an additional column called room #. What I need now is when there are more then one room, I need each duplicate record. To add 1 to the room # field. For example, 3 rooms, room 1 = 1, room 2 = 2, room 3 = 3.
  2. G

    Creating duplicate rows based upon cell criteria

    We have a web form that a user enters info, that is exported out and used internally. We needed a way to create duplicate entries for each number of hotel rooms needed. I know this is not the best way to do this, but my employer wanted to use what they already have in place, so Access and Excel...
  3. G

    Creating duplicate rows based upon cell criteria

    Thanks, so far its working like a charm.
  4. G

    Creating duplicate rows based upon cell criteria

    I am working with some data that needs to create duplicate rows if a cell has any number greater then 1. Here is an example; I have a column named 'Number of Rooms', if the entry is 3, I need the specific columns duplicate 3 times in new rows under the existing row. Number of Rooms Hotel...
See more
Back
Top Bottom