Link data from Another cell
On Tuesday, October 9, 2012 7:20:09 AM UTC-5, sk. shafiqul wrote:
Hi All
I have 6worksheet in a excel file. like packing list, invoice, summary
etc. In a file maximum data is same and we only updating packing list
and invoice another data are automatically updating by link system (by =
worksheet name and cell name). But i need to like some word form source
cell. Example- My invoice is showing vsl name MCC MELAKA, V-1242. but i
need to show only MCC MELAKA in summary in cell E26 and cell name B26
should be shown only V-1242 in same sheet.
If possible please help.
--
sk.shafiqul
Look in the hlep index for MID and LEFT
|