Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am having the following requirement.
when i click on the export button the following st table should be exported to excel with the each region data into one sheet.
per suppose emea region into one sheet, apj into another and ams into one another sheets.
here i am attaching the sample qvw.
below is the data
region | company name | supervisor | sales |
ams | x | sony | 245 |
apj | y | fim | 255 |
emea | z | jen | 265 |
apj | tcs | bin | 450 |
apj | cts | fun | 350 |
ams | bosch | sun | 679 |
emea | lg | ram | 789 |
ams | samsung | rama | 532 |
I am new to macros kindly help me out wit this.
Hi Frank,
Thanks for your quick response.
is it possible to make my code dynamic, there are some formatting in it and also we have first sheet with name of report info and first cell with some text and second cell with another text like below
Study Name: | Subject Gram |
Study Name: | Cohort 2 |
Event_CD | Event_Description |
DTH | Death |
tre | trew |
see attached
Hi Frank,
Thanks for the inputs.
i added the country dimension to my data and i tried to export the table with one country as one file
per suppose india into one excel and indonesia into another excel but it is not working .
Can you please help me to achieve this .
once again thanks for your patience and inputs.
Thanks and Regards,
Ramya
so you want to generate one excel file per country and every excelfile containing the tabs subjid (001-002,....)???
then see attached qvw and adapt the exportpath inside macro according your environment
hope this helps