Posts by Mirinjawbro


    update ------ the code attached works fine, it goes through all locations and saves as needed

    however these 150 locations (files) now have to be sent to the managers. we do not want them to be able to select the dropdown in C2 once its been saved and sent. (so they can see other location cash)

    i can get the dropdown to disable but then the code stops running through as it is set to run through the dropdown in C2 until the end

    all i need is once its saved to disallow the dropdown in C2

    thanks






    thanks so much

    Hello all


    i have a workbook with 150 different locations, these locations are in a dropdown list. as you select locations the table below changes showing the wages etc (works using lookups)


    i need a macro that will


    - move through the workbooks 1-150 and save them in set location

    - MUST disallow dropdown in C2 after saving - wages etc are shown in the table once the location is selected .


    currently these are all on 1 workbook.


    need 150 workbooks


    thanks

    im not sure what you mean.


    Jan - Dec can be labelled as 1-12 if needed.


    so for example


    first line of data


    AAA live date is 12/04. as this is on the 12th day of the month, i will only be summing the 5th-12th month


    if AAA live date was before the 10th day of the month i will sum all months including that month.

    1 2 3 OUTPUT
    8000 10000 15000 Name Term Group Cat
    aaa a i f aaa 1 8000 a
    bbb b g d bbb 1 8000 b
    ccc c d r ccc 1 8000 c
    ddd d f t ddd 1 8000 d
    eee e h y eee 1 8000 e
    fff f y e fff 1 8000 f
    ggg g f d ggg 1 8000 g
    hhh h d f hhh 1 8000 h
    aaa 2 10000 i
    bbb 2 10000 g
    ccc 2 10000 d
    ddd 2 10000 f
    eee 2 10000 h
    fff 2 10000 y
    ggg 2 10000 f
    hhh 2 10000 d
    aaa 3 15000 f
    bbb 3 15000 d
    ccc 3 15000 r
    ddd 3 15000 t
    eee 3 15000 y
    fff 3 15000 e
    ggg 3 15000 d
    hhh 3 15000 f

    Hello



    each week a spreadsheet of numbers is uploaded. the list length varies but the terms and conditions do not. (red at the top)


    i have made the macro copy column a2 down to the end and paste into a seperate tab, then go to b2 and then paste it underneath and so on. thats working and fine


    what i now need is too add 1+23 from A1 the correct number of times to the right of A2 downwards.


    then take 1+23 in B1 and add it to the correct number of lines in B2 downwards


    so , lets assume this has 100 rows


    column A needs to be A2 down to A101 and next to this 1+23 100 times


    if the list was 87 long, id need A2-88 and 1+23 next to it 87 times


    then it goes to the next coulmn and repeats


    thanks


    1+23 1+23 1+23 1+23 1+23
    8000 10000 12000 15000 20000
    20.00 21.19 23.76 28.65 42.48
    20.00 20.00 22.11 25.52 32.35
    20.00 21.19 23.76 28.65 42.48
    20.00 20.00 22.11 25.52 32.35
    20.00 20.00 22.11 25.52 32.35
    20.00 22.39 25.21 30.37 44.25
    28.22 29.76 31.30 47.61 68.58
    20.00 22.97 26.94 32.05 38.95
    31.07 32.96 34.50 52.96 74.98
    31.07 32.96 34.50 52.96 74.98
    20.00 25.15 29.55 35.15 42.15
    31.07 32.96 34.50 52.96 74.98
    20.00 25.15 29.55 35.15 42.15