Here's an easy one........saving when populated

  • Thread starter Thread starter Vato Loco
  • Start date Start date
V

Vato Loco

I have a sheet that needs to save everytime a certain range of cells i
populated. whenever something is typed in a4:iv4, I would like it t
save without prompting. It would also be great if it could save as th
value of a3. If anyone has a fix for this, I would greatly appreciat
the help.

Have a great day everyone, and thanks......Vato
 
Might be nice to know how it is populated and if iv4 always has to be filled
out. Otherwise, you might be saving on each entry.
 
It would be manually entered...and I want it to save each time somethin
is entered in that range. Thank
 
Are you saying that you want the workbook saved each time ANY entry is made
in ANY cell in that range? if so
right click sheettab>view code>left window select worksheet>right window
select worksheet_change
use this inside the macroActiveWorkbook.Save
 
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

easy and cheezy for all you geniuses 5
Look up data from one sheet 1
Populate row with work days 1
LOOKUP 2
Sum help please... 7
Populate Data from Summary Sheet 5
Need to auto-populate a list. 16
Requiring multiple cells to be populated before allowing Save 2

Back
Top