SomethingNew
New Member
- Joined
- Jul 2, 2024
- Messages
- 2
- Office Version
- 2016
- Prefer Not To Say
- Platform
- Windows
- Web
First time posting sorry if I am not posting properly.
I have used the code below previously to automatically input data from one cell to a master data sheet but now I need it to input multiple cells down the column.
To make it submit multiple cells information I tried changing the column range's name instead of just the one singular cell.
ex.
Range A2:A12 changed name to DESCRIPTION
It only accepts the first row of the range and nothing else is listed below, I am unsure if my approach is completely wrong since I assumed the range of cells is included in the Range("DESCRIPTION").Value.
If there's another way to do this or if I'm just making a mistake in my approach I would appreciate any help
I have used the code below previously to automatically input data from one cell to a master data sheet but now I need it to input multiple cells down the column.
VBA Code:
Sub data_input()
ws_output = "SAMPLE FINAL"
next_row = Sheets(ws_output).Range("B" & Rows.Count).End(xlUp).Offset(1).Row
Sheets(ws_output).Cells(next_row, 1).Value = Range("DESCRIPTION").Value
Sheets(ws_output).Cells(next_row, 18).Value = Range("QTY").Value
Sheets(ws_output).Cells(next_row, 19).Value = Range("UOM").Value
End Sub
To make it submit multiple cells information I tried changing the column range's name instead of just the one singular cell.
ex.
Range A2:A12 changed name to DESCRIPTION
It only accepts the first row of the range and nothing else is listed below, I am unsure if my approach is completely wrong since I assumed the range of cells is included in the Range("DESCRIPTION").Value.
If there's another way to do this or if I'm just making a mistake in my approach I would appreciate any help
Last edited by a moderator: