Link data from Another cell
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. |
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 |
All times are GMT +1. The time now is 09:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com