LinkBack URL
About LinkBacks
I want to always have a blank row in my table that has the same format and formulas from the rows above is that possible?
I want to always have a blank row in my table that has the same format and formulas from the rows above is that possible?
1) Highlight your current table
2) Press CTRL+T to activate the Table function.
Now if you start typing anywhere in the blank row below your table it will instantly expand to include your new row, formatting , formulas and all.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi Birpal,
PFA and PFB for the small macro. Paste this code in sheet module which contains the table. In this code, i have used "Sheet1" as sheet name and "table1" as table name, you can change the sheet name and table name as per your requirement. This worksheet change event will run only when you change the value of any cell in the last row of the table. I hope this code will help.
Regards
Please Login or Register to view this content.
Ramandeep Singh
Please Click * icon to Add Reputation if my answer helped!
Hi Birpal,
You get the answer to your question. If you are satisfied with the answer, kindly mark this thread as SOLVED.
If my answer helped, kindly add reputation by clicking on the small "star" icon located in the lower left corner of the post.
Regards
Ramandeep Singh
Please Click * icon to Add Reputation if my answer helped!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks