need to find how many times a set of numbers divide into a total number & pasting row

[bert_da1]

Hi all
I am a noob to excel and need help solving some problems.
(1st post was wrong titled lol..told you i was a noob head lmao apologies).
The 1st is i have a list of ten wood lengths and a total length (sum of them used) and i need to check how many times the largest lenght of wood goes into the total then the next smaller length etc etc until all ten have been checked leaving the remainder. So i can work out properly what lengths of wood are used. i.e 1, 5, 6, 8, etc into say 1668 meters total = 208.5 but if the number has 6 remainder i would like to then check again for 6 then 5 then 1 etc etc.
My second problem is when i copy and paste a row to a new sheet it adds it to the info already there and doesnt move it down a row ready for the next copy paste.
I would apprechiate any help, thanks in advance :

[bert_da1]

TY Donkeyote.
Appologies for any noob mistakes / posts etc.
I am looking for a solution as i am trying to use a workbook now with like 30 pages and the code is all over and some problems have taken me days to try and sort out. I have used examples and watched mr excel stuff etc etc and apart from not wanting to join forums were u risk being scammed by paying a dollar etc, your forum looked genuine and had real coded replies etc. I will also point out if anyone who replies to my threads helps me sort out my spreadsheet, i will gladly give PC component part rewards as i have lots of old pc parts etc in my loft, which may be of use to members as they are gradually being taken to the tip as i have a shed full also. So if any members need old parts let me know what and i will gladly look for them and post them free of charge, (obviously excluding large items like old 21" monitors and laser printers etc etc o.k)

[shg]

How about posting a manual example (a workbook) that shows what you want?

[bert_da1]

hi i dont have a wokbook example as it has been deleted since it doesnt work

basicaly i have a list of say 20 numbers (height / length)all different 1345, 4322, 213, 24, 589, 7543,879 etc etc. and say i have wood planks or metal poles of certain set lenghts 1ft 2ft 6ft 8ft 12ft 18ft 21ft and i am trying to work out how to search the numbers to work out how many planks etc of what size are needed to build to that (height, length). so the number 24 is easy because its just 3 of the 8ft = 24. but when it is a large number i need it to work out you need 218 x 12ft and forty x 8ft and two x 6ft and a 1ft = 127501. i have been trying for ages and haven't a clue. i had the 2 lots of numbers as 2 column lists but i am lost now. It doesnt matter if you have to click a button or if it just calculates it in another colum next to the sizes as a number like this 24 8ft x 3
127501 12ft x 218
8ft x 40
6ft x 2
1ft x 1