Look for next row for automatic data entry

[Elfiraon]

Hi!

So, I have one excel file where in one cell I enter my date (i.e. data). Then I have this other excel file where I want to populate the dates based on the entry. I'm trying to figure out the VBA/Macro for this, the only entry for the second excel file is the data (i.e. one column), and I want my data to go to the next available/empty row it finds to populate.

Any help is appreciated, thanks!

 

[Momentman]

Well, to get the lastrow on sheet1 for example, use

lastrow = Worksheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Row

If you provide ome clarity as to your request, we can help with more of the code

 

[Elfiraon]

My first file I have contains the entry cell called "Entry.xlxs", below is a screenshot of the section with cell I2 for entry.


Then on the second file, I have column A with a set of data in which once someone enters the date on cell I2 on the previous file, it would then populate on this column from the file called "Records.xlxs"


I'm still trying to figure out the code for it! thanks!