Fill in Data

Experts,

I have this excel spreadsheet that I have to update manually.
I am looking to increase my efficiency.

In the attached.  I would need something to fill in the data according to the column to the left.  
I am looking for a button to push and all the data fills in.

Let me know if you need any additional information.  

thank you. fillin.xls
pdvsaProject financeAsked:
Who is Participating?
 
jppintoCommented:
I've attached a working example using the macro provided below. Just select the rows that you want to fill down and click the button.

jppinto
Sub FillCol()
For i = 1 To Selection.Cells.Count - 1
j = i + 1
If Selection.Cells(j, 1).Value = "" Then
   Selection.Cells(j, 1).Value = Selection.Cells(i, 1).Value
End If
Next i
End Sub

Open in new window

fillin-1-.xls
0
 
pdvsaProject financeAuthor Commented:
awesome.   How can I make this available Globally?  
Sub FillCol()
For i = 1 To Selection.Cells.Count - 1
j = i + 1
If Selection.Cells(j, 1).Value = "" Then
   Selection.Cells(j, 1).Value = Selection.Cells(i, 1).Value
End If
Next i
End Sub
0
 
pdvsaProject financeAuthor Commented:
I mean because I will have to insert the code into each excel file I use.  
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jppintoCommented:
Put this into a module instead of a workbook.
0
 
pdvsaProject financeAuthor Commented:
maybe a button would not be what I need then.  
Maybe I just select then run a macro?
0
 
pdvsaProject financeAuthor Commented:
OK I made a Module but the module seems to be only available if I have the excel file open.  I need it to be available in each excel file I open.  do you know how can I do that?
0
 
pdvsaProject financeAuthor Commented:
Not sure if you have seen my posts...
0
 
jppintoCommented:
Sorry for the delay...here's an article that explain how to do it:

http://office.microsoft.com/en-us/excel-help/deploy-your-excel-macros-from-a-central-file-HA001087296.aspx

jppinto
0
 
pdvsaProject financeAuthor Commented:
sweet...it worked great.  Had to read that a few times though.  Thanks for the help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.