I need help with excel, just one little thing. I have some columns and in some rows there is sometimes an amount. I need all tese amounts in one seperate list in a new file. I can show it exactly with picture descriptions: so in [url removed, login to view] you see that in one column is sometimes an amount and in [url removed, login to view] is it how it should look the new list, automatically from exc1.png. when the amount in exc1 is deleted it should also be deleted in ex2.
maybe it is possible to write automatically the date when the amount was added. and it should be possible to sort the new list, with animal, marke, date, notes.
I have a solution, but here it does not work when one marke has amounts at more then one animal, just one is listed. There should be listed all animals with all amounts. (at the example marke xxxx 7 should be listed the dog with 35 and the cat with 90). And the date should also be automatically the date of the day when the amount is entered, if it is possible. If not, not so important.
Hello, thank you for reading my proposal. I am an Excel expert. I am familiar with its functions and automating using VBA. I am willing to do this job at minimum budget. Hire me!