Search results

Hi So this means that each web page needs to be configured seperately to grab data. In cases where the WEB Query gives an error and no data can be grabbed, what can be done? Regards NJ

Hi, Just wondering if any one done this before, i am not good with macros or vb, but was thinking if could have a general sheet with a macro that could grab the data from a given URL. Have seen another Topic...

Great Job well i have some issues, hope that you can be of help. find attached the result in the updated file. https://docs.google.com/open?id=0B5jCQSsK1WJ9M2pRcG9LbmhSajY3RmpvTVRLd0hRZw 1 - if we change any thing (title,date,time columns or rename the function name or sheet name)...

here you go NJ https://docs.google.com/open?id=0B5jCQSsK1WJ9WU1wMzhpNVBSNVN6UW4xLXloNFdRUQ

Hi can any one help on the following (right to left - Arabic), but would prefer a general formula for any language type. Original Text المسلسل التاريخي - أسعد الوراق Final Result المسلسل التاريخي - أسعد الوراق The above has to be true for any case, if we have 2 words, 3 words, 4...

hi currently i am working on this and have no clue how to pull the data that is there in sheet 1, they are not uniformly placed in the table. First of all the data required from sheet 1 are the three values (Dtae/Time/Title) any thing else is junk for me at the moment. How to isolate that...

hi again you have been really helpful, but what i meant was to get the three values (Date, Time, Title)from the first sheet based on a formula, my formula only pulls the next row/cell combination and does not validate the data pulled against all three values, hence not feasible in this case...

Hi Well that is just a part of the requirement, now i don't want to manually paste those values from sheet 1 to the next as i have tens of them to be worked on. we need to get the three values from sheet 1 and not from sheet 2 so as to automate the whole process. Hope i cleared my...

Hi find the results below KURUKSHETRA LOVE KE LIYE KUCH BHI KAREGA (skips to the end) Sunny Deol, Meenakshi Sheshadri (end, but the cast instead of the title) BLOCKBUSTER (goes one event back) BLOCKBUSTER (repeats) any suggestions? Regards NJ

wow! now i have so many options... thanks every one, i thing that should do the job... appreciated once more NJ

24 hour clock issue see what happens when i try to use the formula... =A1-4/24 where the day goes back to the previous date before 00:00 am, we get a negative value or too large value???? 2:00 ####### 3:00 ####### 3:25 ####### 20:15 16:15 22:45 18:45 23:00 19:00 NJ

yes that's right typo mistake

yes only three values from the entire sheet, this is called FPC (fixed point chart), and these values be copied to the second sheet. title of the programs are the ones that appear after the blue highlighted cells, time can be selected from any column preferred, while the date is the one on top...

this is just a single sheet, i have multiple sheets and the date changes on each sheet, hence it is important in that regard so that we have the data for that particular date, and the rest is specific to each sheet. Regards NJ

Ooops my bad ;)

thanks buddy :)

Hi Can someone help on the extraction of data from the first sheet in the format provided in the sheet. Link for the file. https://docs.google.com/open?id=0B5jCQSsK1WJ9VVFYeDM2U2hUaTZNYzhDdHRZLThPQQ Appreciated. NJ

Hi I was looking for some help on calculating time based on a column of time provided. How values are displayed is shown below. Original Time format...............Subtract 4 Hours...............Subtract 9 Hours...............Add 2 Hours...............Add 9 Hours...

one more thing the cells that have value in column C but no value in column A (empty), copy to the second sheet in column D just beside the Column C. A.......B................C....................................D 5.......6................hello world....................."next chapter...

tried that but some how it is not accepting and still takes data up to the 200???? can you generate dummy data and try yourself?

one question why am i not able to go past the 200 mark? Origional!$A$1:$A$200 ??? any data available after that mark does not display, although i tried to modify the formula, still the two ".." appear... any help NJ

you rock :)

Thanks but i think it is a bit too much work for this thing, can we have a one liner formula where it does all that, pick data from sheet 1 and paste the data in sheet 2... Appreciated. NJ

Hi There File uploaded here, https://docs.google.com/open?id=0B5jCQSsK1WJ9RHJmMkJrMTVTSE81c1pGY0tqN3Uydw Any can help on the issue as i want the data from these rows to be transferred to another sheet and look like the one attached below...

Thanks for the code, I'll try the same and update you soon... NJ