I`m trying to record 2 macros and I just cannot get output that I want
First one - From Sheet 2 I need the values to be copied to their corresponding cells in sheet 1. Bear in mind cell E2 has formula =CONCATENATE(B3,"g")
After the first items are copied the next one needs to be copied into the adjcent cell (So E2 (sheet1) to C2 (sheet 2) and so on). The entries for weight and name need to have cell filled in (any) off white colour.
Untitled.png
Second one - In sheet 1 I have the horizontal list that I`m copying across. This list has any number of items (Torch & screw for example). I need the sum for each row in the end column. Their may be 2,3,4 etc... number of items. They must be formatted white text with black filler exactly as the pic with "Totals" written in the bottom cell
I posted here but seems like no one replied.
https://www.mrexcel.com/board/thread...macro.1131219/
Bookmarks