LinkBack URL
About LinkBacks
Please can anyone help, I am trying to get VBA code in Excel to copy formula in specific cells to copy the cell below when an entry is added to a database.
I have attached a spreadsheet, if anyone can help, you have my thanks. Cheers, J.
Please can anyone help, I am trying to get VBA code in Excel to copy formula in specific cells to copy the cell below when an entry is added to a database.
I have attached a spreadsheet, if anyone can help, you have my thanks. Cheers, J.
You don't need a macro, just adjust the formula in cell B2 toand convert the data list to a Table.Formula:
Please Login or Register to view this content.
As soon as you enter data in column B it will insert the formula in the corresponding cell in column A.
See the updated example.
Regards, TMS
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
Thank you for your help. In the problem I have used the same formula as you but I don't want to copy and paste for a 1000 lines or so. I won't be using the database it will be my colleague who is not so excel literate.
I have simplified the problem also there are many other columns with quite a few I want to auto populate once they see a project title (entered in from a UserForm).
If you can help, thank you so much, J.
You don't have to copy and paste any lines. In a Table, you only have rows where data is present. As soon as you enter data manually, it will insert formulae, formatting, conditional formatting and Data Validation. Nothing to do.
Excel stores the formatting and formula (somehow) in the first row of data and it just extrapolates from that.
Suggest you put up a more realistic sample and/or try it yourself.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks