Hello,
When a new entry is added in the Description Column (Column B) I want copy the formulas in the Item #, Status, and Time columns to the bottom of the table. Below is the code that I have so far for the Item# column, but it only copies the formulas down until there is a blank instead of all the way to the bottom of the table. How can I get this to fill to the very last row of the table every time?
Image 8.PNG
Please Login or Register to view this content.
If it's a true table then normally when you change a formula in a cell or I would think if you add a formula to a cell that doesn't have one a little box will pop up that you can click on asking if you want to overwrite the formula in all the cells.
If you choose yes then that formula will automatically populate all the cells and any new cells added in the future.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Skywriter, that is what I thought too but is not the case in this workbook.
The formula in a column MUST be consistent if it is to be propagated.
Try:
A2:dragged down to the end of the columnFormula:
Please Login or Register to view this content.
C2:dragged down to the end of the columnFormula:Please Login or Register to view this content.
D2:dragged down to the end of the columnFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Note: you should NOT need to use code to propagate the formulae. Just add entries to column B.
TMS, thank you for the feedback. In my full workbook the formulas in the first row of the table are different than the rest of the table. This was done to avoid circular references. Using your formula for column A accompanied with some code I was able to get the results desired. Thank you for the responses.
You're welcome.
The point being, if the formulae are not consistent in the Table column, they will not propagate. It can be quite difficult to get different formulae in a column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks