Search results

Thanks for looking into this vletm. Could you clarify which format you're using in your table? everything is coming up for me in a 12:00:00 AM format... Also I have a feeling the formula you're using is still going to return a number where everything to the right of the . is going to be decimal...

Hello, I've built a table to track video footage on a film production, using the INT formula. My initial data is in frame, and I have put together a formula where when I replace "1" by my frame count (ex:107), the formula turns the frame number into seconds + frames (4:11). Note I'm converting...

Hi SirJB7 I was actually thinking about it after posting this message, but i wasn't sure if it was possible, so you just confirmed it was...Any suggestions as to what would be the best way to do it? (sorry my excel knowledge is pretty much limited to fancy vlookup and index formulas...aside...

Hi Everyone I have a similar question and am wondering how to adapt the above macro to my case (or maybe there's a more simple one that would work). I have a list of positions with start and end dates in a table and I'd like to be able to hide the rows when the start date is empty. Ex...

It works great, thank you again !

OK, Something else came to my mind: What if I want to single out some of the names in my list, and not include them in the batch print. This would be helpful for vacation/sick days that i need to manually enter on time sheets on a weekly basis. So i would print those one by one and then single...

It works, Thanks Luke ! and thanks for the short cut tip as well!!

Hi Hui thanks for your input. I tried the code but it doesn't work: It keeps printing blank time sheets - I had to force quit to stop it from printing :P Also, would it be possible to have a different shortcut for it (like ctrl + L for example, something that isn't already used). Thanks !

Hello I started using a Time Sheet template built by somebody else and I'm wondering if there's a way to improve the "printall" macro it contains. Basically I have one sheet that lists the employee with information in 5 columns. Name - Department -Title - TITLE coding - DEPT coding The...

ok, I've got it. I modified your formula slightly to treat the cell as a range rather than individually, then I added a sumif formula to each segment to exclude any cell that contained text and not numbers: =(INT(SUMIF(A2:D2,">0",A2:D2)))...

Ok, now here's another question. If I enter text into the cells instead of time codes, is there a way to exclude these cells from the calculation, so as not to get a #value error. I would know how to use an IF formula on a range but since we're looking at each cell individually here, I'm not...

Thank you SirJB7, I've used the whole formula in one cell and it seems to be working like a charm! Brilliant!

Thanks oldchippy! I posted an example here: https://docs.google.com/spreadsheet/ccc?key=0Aiw0RFW1ZgTndGI2WVVLb1A2NnJQVGc1VGNKNk44M3c the blue columns are data manually input. The format is ss:ff were s are seconds and f are frames. The frame range is 24/s so what I need is to be able to sum...

Hi SirJB7 Thanks for your reply. I'd be happy to upload a sample, but I'm afraid I don't know how :P Is there a link on this page that allows you to do so? As far as the formula I copied, this is from another forum thread, I haven't actually be using it so the D11 and E11 would not be...

Hello I know this subject has been addressed many times in forums but I'm hoping I could get an answer specific to my case. I have a range of time codes in this format: ss:ff (seconds and frames) that I would like to be able to sum up and get an accurate result, with the obvious issue of...

Thank you all for your help!

Problem solved! my workbooks where in two different calculation systems (1900 and 1904). So to conclude, this is the formula that works: =INDEX(Source Date range, MATCH(Linked Name&Assignement,Source Concatenated Column,0)) Now I just need to make sure that using it over the 15 tabs of my...

So, I'm making progress. Using the last formula (=INDEX(Source Date range, MATCH(Linked Name&Assignement,Source Concatenated Column,0))), I do get a date returned (not sure why it's working today but didn't yesterday...), but the value is wrong. Yet when I turn the cell format to a general...

Hi Narayank991 Thank you for your suggestion. I've tried and it doesn't work. It's returning blank or #N/A. Plus, because I'm using a set and varying formulas in the source page, I would have to copy and paste every single cell into the linked workbook for the returned value to be accurate...

Hi Hui Thanks for your input. I've gone over the post, but it seems a bit advanced for my own capabilities. Plus I'm not too worried about making sure the workbook gets updated. I usually have to work on both at the same time, so they're usually both open anyway. My problem for now is to...

ok, so as a test, I've copied and Pasted the value only of some of my source info into a new blank worksheet, and I've used the third formula in my linked document, and it works... so it probably has something to do with the fact my source cells contain formulas....

ok, scratch that, there was a mistake in my formula. the cell now returns 0, when it should be returning a date...

hi Jeremy I concatenated the Name&Assignment into one column, and my formula now looks like this: =INDEX(Source Date range, MATCH(Linked Name&Assignement,Source Concatenated Column,0)) but now I get a #REF error....

Yes, i think you pointed out my mistake, I was concatenating the columns together. I'll try creating a hidden column with the concatenated info from both columns and see if that work. thanks!

Hello I'm trying to link 2 workbooks together so that I only have to update one (source workbook) and the other (linked workbook) updates automatically. Both workbooks have multiple spreadsheets and I am trying to link the two master sheets from each. Basically I have a list of people with...