VBA copy down formulas to next blank row only works with manual entries ?

I have a spreadhseet with som VBA code to copy down formulas in a number of columns to every row with data in column A - I have run into a bit of trouble as the data in column A either comes from a userform or is copied and pasted from another seperate worksheet - I have tried my code with it set on Worksheet_Change(ByVal Target As Range) event and works when userform writes new entry , however when the information comes from the other worksheet , this doesnt work unless I manually click my mouse into the last entry then press enter

Anyone got any ideas how I can make my code work regardless of the method of entry of the data, i tried re-wrting the code to work on worksheet activate and activating it after my copy from another workbook code has run but again this only works if I manually click on my data sheet

I am only new to VBA so got a bit stuck on what is probably a simple issue , tried searching for the answer to this but to no avail

Please Login or Register  to view this content.

thanks in advance

trubster

It is in a worksheet called "data" in my workbook

Thanks trubster

Yes - what i was trying to do was whenever a new entry was added to the data in column A on the "data" sheet , no matter where it came from then the formula copied down in the adjacent columns to save me using formulas in the columns to check if entry was there i.e = if(a2="","",A2*100) as these take up memory regardles of the data so wanted it to dynamically add the formula as the entries grow as the end user of the sheet will not be excel proficient so will not think to copy formulas down manually.

thanks