Posts by mspeight2

  • Transposing data from one of 3 columns into another column when choosing from a list

    Hey guys,


    I have a current work book I use for my stock inventory and invoicing. I would like to adjust it to incorporate multiple selling prices.


    The workbook works off a 30% mark up on cost column E, and this adjusted value is represented in column J.


    I now need to incorporate different mark up rates for 3-4 different customers i sell to.


    Im not too sure on how to approach this and I would love some pointers, even if it is a link to another thread ( which I cant seem to find )


    So basically I have different fixed prices for each one of the 3-4 clients i sell to. And i would like a drop down list in one cell on the stock tab which I can select, and once I have done that for it to auto populate column J with the predetermined values.


    i cant seem to upload my excel workbook either @194kb?? any ideas?


    Thanks guys!

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    Hey mate!


    I was wondering if you was up for giving me a bit more help? The data tab is getting quite muddled up and its not exactly logical to work through at the moment. I am wanting 4 data tabs with up to 300 item entries (A6:A306) each tab would have a different name. Cables,fixings,misc,hardware.


    I have been asked by the director of the whole company to implement these changes so the work can be used by all the installation companies!!!


    I have been enquiring for the last hour or so to try find someone local to help us with this, and no one seems to be able to write code for excel! So..... the company is prepared to pay for the extra work on the workbook!


    Let me know if you can help :)


    Mike

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    Hey mate!


    Yeah its been a great start to the week so far knocking out the invoices and changes in stock like there is no tomorrow! thanks again!! Ive copied the work book to run as a quoting tool :)


    All i have done is change the data on the template tab to show "quote" rather than invoice and I can generate a quote with just as little effort as an invoice!!


    However I have a issue with new entries I have added in column A108< (A108:A300) Any item in cells A6:A107 transposes perfectly to the template tab.


    The new items do not transpose onto the template tab when i press the "invoice" button on the data tab. I have tried to change the code but i'm not having much luck. I have attached the file with this message if you have anytime to spare me.


    Thanks Heaps this workbook is awesome!!!
    Mike

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    I get exactly what you mean now! sorry mate i just have my head up my arse with all the workload ive got at the moment but it is clear as day now ive had a bit of time to run through it.


    We got their eventually mate! i can not thank you enough for the time effort and patience you have given me over the past weeks or so. You are a credit to this site and if their is anything i can do for now or in the future please ask!!


    regards
    Mike

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    Hey dude!


    I managed to have a play with the workbook this morning and got to a point (with simple formulae changes,no coding!) to something that Will be an awesome tool for this company!!


    The only issue now lies with clearing the invoice tab (of just the materials and their cost from the sheet when needed) It would be awesome to have a button on the tab to clear the contents. (These content are in cell C19:C39 D19:D39 E19:E39 F19:F39 G19:G39 H19:H39 I19:I39 J19:J39 K19:K39 L19:39)


    I have attached the latest file with the changes I have made. I hope it hasn't mucked around too much with your overall model!)


    The way i imagine the workbook to work now is...


    I enter the stock used


    I click "new invoice"


    I enter labour charges in the table at the bottom of data tab.


    I click onto the template tab.


    I print hard copy


    I save file


    I press "clear invoice" button on template tab.


    I re-save


    Close file


    Reopen last saved file to repeat the process.


    hope this makes sense, im sure i can manage for the time being with the model i have, if you are sick of changing this thing for me!


    Thans mate
    Mike

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    Thanks for all your help Smallman, you have been an absolute star putting up with all my demands and poor descriptions of how i wanted this workbook to operate. When I get time at work tomorrow i will print out all the different coding from earlier models. And hopefully i will be able to see how you have changed it from one to the next.

    I haven't had time to look through your latest file attachment but I will tomorrow.


    Thanks again mate your a legend!!:)


    Mike

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    yeah alls cool with the options you have given me for the "labour" transposing issue :)


    ok for an example:


    2 in D6 (QTY)


    4 in F6 (stock left over)


    5 in G6 (maximum stock held)


    1 in M6 (no.of items to order)


    4 in N6 ( last saved stock)


    Then press the SAVE button at the top right of tab 1. And the figures should calculate to the following.



    0 in D6 (QTY)


    2 in F6 (stock left over)


    5 in G6 (maximum stock held)


    3 in M6 (no. of items to order)


    2 in N6 (Last saved stock)



    Hopefully this clears it up for you.


    Mucho gracias!

  • Copying certain cells from each row to another sheet for invoice

    Re: Copying certain cells from each row to another sheet for invoice


    Sorry again I'm mis-reading your posts. cool.....


    I need (=K301+F303) into cell M41 on the invoice tab


    then....


    =M41*1.15 into cell M43 (all these cells are on the invoice tab)


    then....


    =M41+M43 into cell M45 (all these cells are on the invoice tab)



    I hope this makes sense :)


    Regards Mike