Search results

Hi All, Can anybody help me on this? I need to select 2-3 options from the pull down menu list and it should appear in single cell separated by comma. Is there a way to get it without using VBA? Thanks, Dee

Hi, I have my pivot table in Sheet2 (Rows - Qtr implemented & Project manager, Column - 2010 impact)and i need to extract data in sheet3 based on Qtr implemented & project manager which is there in column 'B' of Sheet3. Thanking you in advance, Dee...

Hi... May i know what is wrong in this formula. I am getting result as "False" instead of Please look into it OR All well. =IF(AND($P4="1 Phase",DO4=""),IF(AND($P4="2 Phase ",$DQ4=""),IF(AND($P4="3 Phase ",DS4=""),IF(AND($P4="4 Phase ",DU4=""),IF(AND($P4="5 Phase ",DW4=""),"Please look into...

I have a list formulas which I need to paste as formula. The only things missing in this formula is "=" sign in the beginning of that formula. Can you guys suggest me how to add "=" sign before this text so that i can convert this set in to formula at one shot. Thanks, Dee

Clarity, Please check my file here.... http://cid-32a21c6cfffd8b0b.profile.live.com/ Thank you very much

HI TessaES Thank you very much for your help. I tried with this.Here the problem is some rows will be missed from that of the source file. And one more issue is after column DI i have formulas which links to the share point site but when i run the macro this link gets disconnected and...

Here is the codes... Dim Ftwbook As Workbook Dim Thiswbook As Workbook Dim LastPM, LastCell, RIndex, counter As Integer Dim Wksheet As Worksheet Dim Flatfilename As String Dim Filewithmacro As String Application.ScreenUpdating = False Flatfilename =...

Can you please suggest where i can upload the file? i don't have any idea about it... Thank you

Hey Chandoo, thanks for the help. In both the cases (source data & In-work file) the data is there till DI. In In-work file i have lot of formula which pulls data from some other file from share point site.Whenever i run macro it is removing the data in the cells beyond DI. Thanks, Dee

Clarity, Thanks for the help. But its quite a big file and i am not sure this will help. I would like to share my file with you if you give me your mail ID Thanking you, Dee

i have written macro so that it extracts data and replaces the existing contents of the whole sheet. But now i want to restrict this to only some columns say till column DI. How can i do this? Can anyone pls help me with codes. Thanking you in advance, Dee

hey! I am creating monthly dashboard where i have 8 tables which contains on an average of 4 on an average of 6 rows and 7 columns. My boss is not interested in graphs and thinks that leadership team don't understand this...but i want it as they are simple n comprehensive. Can you guys suggest...

Hey! I have question on this macros. i have written a macro which pulls the data from share point site and also update the pivot tables links this data. The issue is that this is taking more time like 5-7 mins and also that data sheet is taking much time to scroll to left/right or up/down. Is...

I have created a template using macros in excel. I have given the option of adding the new sheet/template into the file. In this template one can copy paste the picture. I have like that around 50 sheets/tabs in a file and each tab is containing minimum of 3 pictures.Every time we open this...

Hey! guys please help me in recover the password i used to protect the sheet in excel. I protected the excel sheet with password, i think i misspealled it so now unable to edit that sheet. i tried googling but not successful...can you guys help me? Thanks, Dee

Hi, I am just wondering how to inactivate rows and columns as it is done in "Christmas Gift List".In this file only 65 rows and 13 columns are active,all other are inactive. Can you help me in this? Thanks, Dee...

Hey Guys, Here is the link to SPSS forum. You can register to login and start posting your queries or share your knowledge with other community members. Hop it will be useful. http://forums.spss.co.in Happy Learning & knowledge sharing, Dee

Hi, I am trying to get Qtr wise sales from Year and quarter column.i have few columns containing Sales, year, Quarter.I am trying to get quarter wise sales using Year, quarter & sales columns.If sales is 300 year is 2009 and Quarter is 3rd then it should value 300 in Q3 of 2009. IF year 2010...

Hi, I am strucked in creating a template. I need to add a image into my template in which it has to fix in specific size. Can you guys help me in this? If i forward the template with image the receiver should be able to view it withour editing or clicking. Thanks, Dee...