RattlingCarp3048
Board Regular
- Joined
- Jan 12, 2022
- Messages
- 166
- Office Version
- 365
- Platform
- Windows
I found a similar post related to what I am trying to accomplish but it didnt work for me, thought you guys might be able to help out. Id like to create a trigger so that anytime a user changes the drop down list in column B to "water" or "food" it will automatically move the row from sheet 2 to sheet 6 next available row. heres the thing, i dont need to move the entire row, just most of it and insert any missing column headers.
i dont really have a VBA code started as nothing has worked so far.
From sheet 2: Copy A-D and Z-last column
On sheet 6: paste A-D (same headers), insert missing column headers, and match/paste Z-last column from sheet 2 into the matching column on sheet 6.
in this example, column headers Z-AA-AB are missing from sheet 6 so they need to be inserted before pasting the data
i dont really have a VBA code started as nothing has worked so far.
From sheet 2: Copy A-D and Z-last column
On sheet 6: paste A-D (same headers), insert missing column headers, and match/paste Z-last column from sheet 2 into the matching column on sheet 6.
in this example, column headers Z-AA-AB are missing from sheet 6 so they need to be inserted before pasting the data