Search results

as far as I remember the formula goes like this file:///c:usersowner......

@ BOBHC and RVIZ thanks for the reply But when I downloaded a zip file from chandoo templates which contain excel sheets it has hyperlinks its working fine if I move to some other computer or to other folder. SO I request you to check it

Hi friends This is an easy task to many of you but I am finding it very difficult to solve it.. Problem I have created a New Folder in "my documents" and had 2 excel files in the New Folder named it as excel1 & excel2 I have given hyperlink of a cell in excel 2 from excel 1 file...

Ohhhhhh my GOD I am very happy and over joyed to be in this forum and to meet you guys...... Here every one is kind hearted and happy to help......You guys have a magic wand with you.........Be it any problem in excel you will give solutions......... every one has their own unique...

@ Debraj I didn't get you what does that mean????????

@ All I have uploaded the file please check it here http://speedy.sh/xEtfF/4.xlsx

Hi I have data in Sheet1 from A1 to A500 and B1 to B500 and so on upto ABC1 to ABC 500...... Now in Sheet2 A1 I need =sum(sheet1!A1+sheet1!B1) when I drag the formula from A1 to B1 in Sheet2 excel is writing the formula as =sum(sheet1!B1+sheet1!C1)........but I need...

Dear Narayan Please leave this I have found an alternative...... Instead of locking the year .....I just copied the whole sheet data to another sheet without formulas and Hyperlinks the numbers (Which you have taught me earlier Thanks for the effort you put in here........ Narayan if...

HI Narayan Thanks for the solution its working fine......... I dont need any further modifications.......I am happy no no Very happy with this

Hi Deb Thanks for the solution you have provided....... You have taught me a new idea (I am not aware of Indirect) Anyways its working..... But the probs is I have 400 Columns and 500 Rows HOw can I apply this to all?? Anyway thanks for the solution

@Kaushik & vallabha Thanks for the reply guys...... but its not working......... Let me make myself clear one more time For Ex A1 to A10 1 2 3 4 5 6 7 8 9 10 Now in B1 the formula I had written is =sum(A1+A2) when I drag it to B2 excel is writing as =sum(A2+A3) but I need...

kaushik Thanks a ton for the solution Its working........ Like you, I am also waiting for some better approach

I have data in Column A i.e. A1 to A1000 now I want to sum two rows and need the value in Column B So in B1 I have written =SUM(A1+A2) when I drag the formula to B2 its writing as =SUM(A2+A3) but in B2 I need =SUM(A3+A4) How to make that ... Plzhelp

Dear Narayan I don't know even ABC of macro(VBA) even don't know where to apply in excel... If G2(Year) is the problem will lock G2 to that year i.e. 2013 and for 2014 I will prepare a new workbook If the above solution doesnt work then proceed with VBA... From today I will start learning...

Dear Narayan You are my excel guru...... Because as a newbie I am finding tough to understand the formulas, tried to learn myself by googling it but not found anyone with such an detailed explanation......Though these are basics to you Its a big devil for starters like me I have tried some...

Dear Muneer Thanks for the reply ..... But the formula you have given is not working for my problem.... Kindly go through my question once again and check this file http://speedy.sh/dzjr9/Sundeep.xlsm .... If I am unable to wrong in understanding your formula ..... Plz guide me Anyway...

Hi Narayan That's great, you have made it exactly the way I need...Thank you very much Also please provide me the other solutions 1)So when we entered 20 in Sheet1 D4..... The Rows in Sheet2 from Row 23 should be hidden and if typed 30 from Row 33 its should be hidden 2)In sheet3 we need...

Dear Narayan Thanks for such an detailed explanation.....One more doubt in Point #3 regarding COLUMN(A1) in A1 column I have not written any number how its taken as 1 and so on I have learned how to write it.........Thanks for that Now I had one more stop ..... How to hyperlink a cell that...

Thanks for providing such a great link I have joined it

Thanks Narayan, That works like a gem.... Problem here is it works to link Jan 1 to Jan 31... but while trying to copy it Feb1 its not working ...Plz help One more request..... Plz explain the formula =HYPERLINK("#Sheet2!"&ADDRESS(ROW()+1,COLUMN($B$1)+(COLUMN()-3)*2),COLUMN(A1)) As far as...

Sorry Narayan I am not clear to you and Thanks for the quick reply I have uploaded again. Please check here http://speedy.sh/UBjGd/1.xlsx For your question 1) I need Product 1 through Product 20 ( i.e. Product 1, Product 2, Product 3,..... Product 20).... Yes if I enter 20 in Sheet 1 D4...

Thanks Hui for the help Sorry I might have not conveyed you my question rightly. I am attaching a file here please check it http://speedy.sh/AZVVW/2.xlsx Please look it at once and kindly explain me how to do Thanks you very much for the help

Hi Narayan Thanks for the reply I have uploaded the file... http://speedy.sh/vSNnB/1.xlsx I am beginner in excel please explain how to do this. So that I can do myself in future.. Though its a cake walk for you for me its a bigstone to cross... So kindly explain me the solution for problem...

I am failing to prepare the excel I need....I need to cross two steps to complete my excel sheet which I need First problem I am entering a sales data of different product i.e. Product 1 to Product 10 every month in sheet1 and Doing its totals in Sheet2 (Monthly totals of each Product and...

I want to hyperlink from a cell on sheet 1 (B2) that links to the info on sheet 2 (C2). So far so good, I've done this. What I can't work out is how to copy the hyperlink so that the row cell reference changes in context so that sheet1 B4 links to sheet2 C4, B5 to C5 and so on without editing...