Copy data into cell by cell
It was little bit confusing when I explain earlier.
If anyone can give some solution using vba will be exciting for me.
Currently I am using formula which work great but when user delete or insert a row which left #Ref# in formula cell.
My data is like example below.
Account Dept Debit credit
1222 88 12.00
1556 99 345.52
6689 45.63 45.63
5589 20 25.56
Actually I was trying to copy user’s input data into another worksheet. Like when user key in data in Sheet1, cellA1, CeLLA2, CellA3, B1, B2, B3... etc the same data I want to copy into sheet2 cell A1, B1,B2, B3 in a specific format. All I want to add pipe (|) at the end of each cell of data. And in Column A and B's data I want (` `) single quote sounding Ex.(`1222`| `88`|12 | ) the data. Rest (Column C and D) no quote.
One more thing if no data on debit column I want to use | (pipe) on beginning and end of data of credit column.. like |345.52|
So the final data I like to see is as follows
`6689`| |45.63|45.63 |
Thanks for your valuable time.