Call a table

%3CLINGO-SUB%20id%3D%22lingo-sub-2930720%22%20slang%3D%22en-US%22%3ECall%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930720%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20call%20an%20official%20table%20in%20excel%20without%20a%20macro%2C%20In%20the%20given%20sheet%20i%20am%20calling%20tables%20through%20indirect%20function.%20But%20the%20challenge%20here%20is%20format%20of%20cells%2C%20I%20want%20the%20same%20format%20as%20it%20is%20in%20the%20table%20when%20i%20call%20a%20table%20in%20a%20different%20sheet%2C%20But%20it%20is%20picking%20up%20a%20different%20format.%20I%20want%20those%20data%20to%20be%20viewed%20on%20my%20mobile%20phone%20and%20macros%20does%20not%20work%20in%20IOS%20device.%20Searching%20for%20a%20quick%20and%20easy%20solution.%20For%20more%20clarification%20i%20have%20uploaded%20a%20Worksheet%2C%20Please%20let%20me%20know%20if%20there%20are%20some%20questions.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2930720%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2931739%22%20slang%3D%22en-US%22%3ERe%3A%20Call%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2931739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1189141%22%20target%3D%22_blank%22%3E%40yugal40%3C%2FA%3E%26nbsp%3BDoes%20the%20attached%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2934723%22%20slang%3D%22en-US%22%3ERe%3A%20Call%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2934723%22%20slang%3D%22en-US%22%3ENo%2C%20As%20it%20is%20not%20supported%20by%20an%20iPhone%2C%20As%20the%20purpose%20of%20doing%20this%20was%20to%20view%20it%20in%20my%20iphone%3C%2FLINGO-BODY%3E
Contributor

Hi There,

I want to call an official table in excel without a macro, In the given sheet i am calling tables through indirect function. But the challenge here is format of cells, I want the same format as it is in the table when i call a table in a different sheet, But it is picking up a different format. I want those data to be viewed on my mobile phone and macros does not work in IOS device. Searching for a quick and easy solution. For more clarification i have uploaded a Worksheet, Please let me know if there are some questions.

Thanks

3 Replies

@yugal40 Does the attached work?

No, As it is not supported by an iPhone, As the purpose of doing this was to view it in my iphone
I see, too bad then.