jocker_boy
Board Regular
- Joined
- Feb 5, 2015
- Messages
- 83
Hi,
I have a table in sheet "BoM" with values between "A:H", with the column "I" and "J" empty, only with header.
I'm trying to copy one value ("D2") from sheet "teste":
To paste that value to sheet "BoM" on column "I" to all empty cells in this column until the last row of the table "A:H".
And then repeat to copy the value from "E2" from sheet "teste" to the column "j".
Many thanks,
Gonçalo
I have a table in sheet "BoM" with values between "A:H", with the column "I" and "J" empty, only with header.
I'm trying to copy one value ("D2") from sheet "teste":
VBA Code:
Sheets("teste").Select
Range("D2").Select
Selection.Copy
To paste that value to sheet "BoM" on column "I" to all empty cells in this column until the last row of the table "A:H".
And then repeat to copy the value from "E2" from sheet "teste" to the column "j".
Many thanks,
Gonçalo