Formula/Macro to place data on the next blank row

  • Thread starter Thread starter Amotif
  • Start date Start date
A

Amotif

Hi everyone,
I'll be grateful if someone can help me set up a formula/macro through which
data can be placed on the next blank row. My intention is to create a
database of info and update the list sometime before I choose new dat (ie,
the existing quotation details can be saved in the database before the new
quotation is generated).
Thanks.
 
The following takes user input and placesit in the next available cell in
column A. You can adapt the technique to your needs:

Sub hfdsjf()
n = Cells(Rows.Count, "A").End(xlUp).Row + 1
v = Application.InputBox(prompt:="enter value", Type:=2)
Cells(n, "A") = v
End Sub
 
Great!
Could this also be applied to place data in a number of rows (ie columns A
to X) in one hit?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data to the next blank row 0
Deleting blank rows with formulas in them 7
Import to the next blank row 2
counting blank cells within two columns 2
Need Macro to autofill formula to last row with data 4
How To Have A Cell Be Blank If... 2
Need macro to move to first blank cell in column 6
macro to insert row and copy previous row + excel 12

Back
Top