Trans cell data in function VBA i guess
Posted by Jonny D (Jack in the UK's FRIEND) on January 26, 2002 5:13 AM
I have anasty little projrct :
Row A reads date,product,vaule,cost,VAT (Tax@17.5%), Tax amount,total followed buy loads of reporting data
In Row B fill in data entry
My problem is this, if VAT is filled in ie <>=0 then i need to copy that cell value to Column in thta same row, but it changes each time, i need a pop up box where i enter column on same row to copy over as same formula not value so editing is possible.
As always millions to do and will be added to each day.
some 79 columns no less with poss any of about 60 to choose from.
I have tried custom function but that means i have to copy down and it all goes wrong, i guess target as to copy over subject to input box result - else it copy and manual find the cell and paste..
Any ideas, i hope i have explaine enough..
Jonny D (Jack in UK's friend)