Search results

Hi again, Thank you everybody for being kind. It helps me go through my relationship with excel a bit better everyday. I have this formula (='Test.xlsx'!$E$14) to return the value of another sheet's cell. My problem is whenever the source cell is blank , it'll return 0 and if the value of...

Hi Kris, I changed the line and it now updates great. Thank you so much for being so helpful. What if I have a more fields added to Name, Gender, ... *** If IsArray(Hdr) Then For i = 1 To UBound(Hdr, 2) If Len(Hdr(1, i)) Then dic.Item(Hdr(1, i)) = i Next Else dic.Item("Name") = 1...

Hi Deb, Thanks for your suggestion and the reading. I've learned a lot. I will incorporate this into my final sheet. -Mel

https://www.dropbox.com/s/c0ry0nd65ujb8is/Questionaires.zip - when I press CTRL + M to run the macro, it adds the new details from the files but it also copies the initial data. Is it possible to only add the new data? Please assist. Any help will be greatly appriated. Thanks.

Hi Kris, I tried the code above! It works perfectly! It captures all the common fields in the questionaires even with different filenames. But there is a problem, when I add a new questionaire in the folder, then I open the master file and run the macro, it will repeat the original content...

thanks kris, let me try this and il let u know..

Hi Narayan, It worked now! Thanks for the explanation. But then, I also understand that this will only work if the files have the same sequential file name (Questionaire 1, *.2, *.3) and the all the files have to be open at the same time. Which means sending the master file as the summary...

Hi Debraj Roy, I just have a question with this code.After clicking the icon in Quick Access Toolbar, then choosing the files to consolidate, it will generate a ****.csv file with all the sheets combined in it but then it leaves the CombinedMultiple.xlsm blank. Is this file's purpose only to...

Hi Narayan, Thanks for your patience. I triend to do it again with all the questionaires 1-3 open but i get this.Please see & advise what I am doing wrong. https://www.dropbox.com/s/rdjvufby41nirk6/Screenshot.jpg

The questionaires will come every 2 weeks, then I'll put in a folder. I was hoping to first run a macro (no idea how to do it :( ) to consolidate all workbooks into one workbook .csv file, then il make a master file with fields referring to the csv file. So, everytime there is a new...

Hi Narayan, I tried your suggestion but I get #NAME? Also, I'd like to inform you guys that the questionaires file name might not be the same or sequential since it will be coming from different departments. The only thing in common is the sheet name and the sheet format. Thanks.

Hi Narayan, Sorry, I didn't see your reply. Let me try it and I'l let you know. Thanks.

Hi Faseeh, Thanks for acknowledging. I have separate workbooks for each questionnaire with one sheet each, all have the same format. This questionnaires are sent to me in a weekly basis so I need to add them to a folder and I need to have a master file where all the details can be viewed...

Hi bobhc, Thanks for highlighting that. :) I will take noted of this next time.

Hi, Can you give me an idea on how to compile questionnaired in one workbook with the format in the consolidated excel file found in belows link:https://docs.google.com/folder/d/0B8ipP_XUVnFwRXZ1aHhFYV9PY0U/edit Thanks.

https://docs.google.com/spreadsheet/ccc?key=0AsipP_XUVnFwdE45Rl80MkhVXzB1c3Zlb1pBTVZfaEE Then , I was thinking. If I am able to get the Target Completion Date based on the type of resolution which I have to get somewhere, then I can calculate if this particular task passed the SLA. Does it...

Hi All, I am just wondering if this is ever possible. :( I have been trying my best to make this as easy as possible for 2 weeks now but the only thing that would work is to manually do it. I have been tasked to send a report based on the following requirement with only these column...

Hi Faseeh!! Wow! That was amazing! You are amazing! It worked after I read all the changes u made! Thank you. For my learning, can u help me explain how the formula worked? I would like to understand it. Id do not know how the index work and the time value. Why did the space in my column B...

Hi Faseeh, I entered the formula in E2 , dragged it down but I get this result . does it have to be formatted in a different way? thanks for ur help/ #N/A #N/A #VALUE! #N/A #N/A #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!

Hi, It's me again. I need your help on calculating the service level if it passed or fail based on a requirement. So far, I have only managed to create this: =IF(O:O="","", IF(AND(D:D="SL 3",O:O<=TIME(12,0,0)),"Pass","Fail")) This works for one argument but if I do nested if, it does...

Hi All, Thank you so much for all the recommendations and tips, I will take this seriously, except for SirJB7's not so latest post.. *_* It is appreciated. :) -melzjm

Hi All, Since , I came across this forum, I have been really encouraged to teach myself VB scripting to do Macros and other things, pick up another skill but the problem is I do not know where to start. Please recommend any site or books that I could read to kick off my self study. I am a...

Hi kchiba & narayank991, Thank you so much for your help, I have tried both solutions and it worked! I am so happy to learn something new and I very thankful for people like you who gives their time to help. God bless you. :)

Hi All, I need your help because I am new to this job. I have a table (figure 1.1) and I need to arrive to a result for my weekly report (1.2). I have tried pivoting but I cant count the 4+ weeks. This report format was given by my boss. Please see example below...