LinkBack URL
About LinkBacks
Hi,
I need a macro for the following condition
In A2 : I entered any text or number
Then the formula of B1, C1, D1 must get copied in B2, C2, D2 & so on.
thanks in advance
copy Formula & paste in same column next cell when previous column is not blank
Hi,
I need a macro for the following condition
In A2 : I entered any text or number
Then the formula of B1, C1, D1 must get copied in B2, C2, D2 & so on.
thanks in advance
Place this code in the Worksheet_Change Event in the VBE for your sheet
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Why don't you convert the data to a Structured Table. That will automatically copy formulae down to new rows and you won’t need VBA.
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
@Alan ... and switch Event Handling off and on again
Please find the attachment of the sample file & @alan the macro provided by you isn't functioning kindly see the file.
Kindly tell me how it works OR how I can use it to function properly?
Re: copy Formula & paste in same column next cell when previous column is not blank
I have got this code on other site....
It's not worked properly even if I have not deleted above blank rows of data of column F
I want to copy only formula rows as well as when I copy multiple cells i.e. records & paste in column F below last records then code must be worked....
Please find attachment for your kind perusal.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks