Hello friends,
I have this work book that I use to keep track of inventory values on different locations. I attached a small sample file.
I'm looking for a macro that allows me to insert a row below an existing row that has formulas and data. The inserted row would have to have the same formulas as the row above. The blank row would only show the formaulas as I would manually insert the data values.
I would also like for if the macro can allow me to delete a row as well.
If it can be done, can there be a message box that asks me where i would like to insert or delete the row, for example, i want to Insert a new row with its formulas under "Brazil" or would it just be able to ask for the row number?
Thanks to all..