Hi
I'm trying to paste a value from oneworksheet to another (invSheet toPayment sheet), which sounds simple enough.
Ihave 4 ranges in the Payments sheet. These are PayNames, SeptPaid,OctPaid andNovPaid.
Myissue is that I need to find the name in the PayNames range that matches cell B4 on the inv sheet(is also on B16 onthe payment sheet), then paste in the amount from the produced invoice(Invsheet) - in this case £40.(B7) into the appropriate column for the month being used.
Eachmonth a different range for pasting purposes is used. I've attached a sampleworkbook .
Ihope this is clear.
Dave
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!