Hi Experts, Newbie to Visual Basic here:
I need help with a macro please. Each day I will receive a spreadsheet and load it onto the second tab "From Vendor" of the attached workbook. The amount of lines could vary anywhere from 2 to 50 so I need the macro to be dynamic. I need to transfer data from the second tab to the appropriate columns on the first tab "Shipment". The Header Row needs to stay hard coded and the cells highlighted in blue need to stay hard coded and need to be copied down x number of lines depending on how many rows are on the "From Vendor" tab. I have recorded a macro to pull the information from the second tab to the first tab but I don't know how to get it to repeat for n line nor copy down the hard coded cells n line. Can someone help?