Auto populating data
Closed
venktesh
Posts
2
Registration date
Wednesday July 26, 2017
Status
Member
Last seen
July 27, 2017
-
Updated on Jul 28, 2017 at 04:26 AM
Blocked Profile - Jul 28, 2017 at 04:53 PM
Blocked Profile - Jul 28, 2017 at 04:53 PM
Related:
- Auto populating data
- Grand theft auto 1 download - Download - Action and adventure
- Grand theft auto v free download no verification for pc - Download - Action and adventure
- Facebook auto refresh - Guide
- Nvidia drivers auto detect - Guide
- Auto redial - Guide
1 response
Welcome!
I will assist with the syntax, and explain what each does, but I will not write a turnkey solution.
z = Cells(ThisWorkbook.Worksheets(WS).Rows.Count, 1).End(xlUp).Row
This line finds how many rows are on a particular sheet called WS. Use this to find the last line on you master sheet.
ThisWorkbook.Worksheets("Logging").Select
This line selects a worksheet called Logging.
ThisWorkbook.Worksheets("Logging").Range("a" & thecelltoinput).value = whatvalue
This line places a value in the form of a variable called whatvalue, into a cell range of A and what ever number variable of thecelltoinput happens to be. SO, if thecelltoinput=1, then this would place it in A1.
ID = Range("B" & whatrow).value
This line, populates a variable of ID, with the value at B, and whatever the variable of whatrow is, to make a RANGE(B1), is whatrow=1.
This should be enough to do what you are asking.
It's kind of fun to do the impossible! -Walter Elias Disney
I will assist with the syntax, and explain what each does, but I will not write a turnkey solution.
z = Cells(ThisWorkbook.Worksheets(WS).Rows.Count, 1).End(xlUp).Row
This line finds how many rows are on a particular sheet called WS. Use this to find the last line on you master sheet.
ThisWorkbook.Worksheets("Logging").Select
This line selects a worksheet called Logging.
ThisWorkbook.Worksheets("Logging").Range("a" & thecelltoinput).value = whatvalue
This line places a value in the form of a variable called whatvalue, into a cell range of A and what ever number variable of thecelltoinput happens to be. SO, if thecelltoinput=1, then this would place it in A1.
ID = Range("B" & whatrow).value
This line, populates a variable of ID, with the value at B, and whatever the variable of whatrow is, to make a RANGE(B1), is whatrow=1.
This should be enough to do what you are asking.
It's kind of fun to do the impossible! -Walter Elias Disney
