Search results

OK. Thank you once again. I appreciate your help. Matt

Thanks again Nebu. Still not quite there though. I've looked at your code and can see PasteValuesAndNumberFormats and then you have applied various other formats. Is it possible to paste everything except for formulas? This would then include all formats that I'm wanting ie numbers, alignment...

Hi Nebu. Works great. Is there any way to export all formats as well? (numbers, alignment, borders and shading) I have split the description field on the Variations sheet because I need to add some data above the headers and need to align it differently. Due to this I have had to shade the cells...

Hello, The intent of my spreadsheet is to use it as a 1 stop shop for pricing and tracking project variations. It is structured as follows; 1. Register - Summarises all data from Variations sheet 2. Variations - Data entry sheet to populate all variations information 3. Database - List...

Excellent. Thanks Hui. Matt

Thanks Hui. Works great. What if I wanted the last text entry against an item to be shown against all items ie replace all dates with text? Refer attached.

I need a formula to provide the max date of each item. Formula needs to be in Column C of attached spreadsheet. Thanks in advance. Matt

Thanks Asheesh. Works well. I have changed source data now but you have given me something I can work with. I might come back to you for some more help once I've further developed conditions etc. Thanks again.

I have an Excel table for entering timesheets into which needs to be converted into a database format for uploading into our accounting software. I have attached a file to show you what I'm after. Thanks in advance. Matt

Hi Narayan, Perfect. Thanks again. Matt

Hi Narayan, That's correct. Formula would need to account for Drawing No's being in random order as you mentioned. I am using your previous formulas so maybe these might help you with a new formula to do this new task. Matt

Hi Narayan, Is there a way to create a Sequence No against each Drawing No so that you can keep count of how many revisions? For example; Drawing No Sequence No (or Count) 123456-A 1 123456-B 2 123456-0 3 123456-1 4 123456-2 5...

Hi Narayan, Excellent work! You are a true Excel Ninja! :) Thank you so much for your help. I might have some more queries as this is only the beginning of a very complex spreadsheet... Thanks again Matt

Hi Narayan, If there is no earlier revision of a Drawing No, then output should be "-". Matt

Hi Narayan, It looks like your formula is returning the Previous Revision of the Maximum Revision (Column G). What I am looking for is the Previous Revision of the Drwg No (Column A). Please refer file I previously uploaded. Thanks Matt

Hi Narayan, Perfect! This works great, thank you so much. Is there a way to identify the Previous Revision as per Column F on attached? Matt

Hi Narayan, Thank you for your prompt response. I think I know what you meant by your Q4 earlier. I have tested your formulas and they work while the data in column A is in ascending order i.e. alpha and then number. The data I have needs to be sorted frequently (by other data not mentioned in...

Hi Narayan, In answer to your questions; 1. Yes. I have chosen the underscore as the delimiter. It could be anything else i.e. / - ^ etc 2. There could be. It would depend on the author. These could be removed and/or replaced if need be. A common Drawing No example would be "7482-035-EL-006_0"...

Hi all (again), Another formula I would like (in Column D) is to identify the previous Drawing No Revision No i.e. row 2 would not return anything, but row 3 would return "123456_A", row 4 "123456_B", row 5 "123456_0" etc. Forgot to mention that Drawing No's and Revision No's can be various...

Hi all, I am trying to track revisions of drawings. Drawings have text revisions when they are not approved for construction and then revert to numbers when approved for construction. For example, in column A, Drawing No's are as follows with Revision No shown after the underscore; Drwg No...

Thanks Hui. I had a feeling it might be that simple...

Hi all, My data in column A has duplicates. I am trying to write a formula in column B to identify the occurence number count of each duplicate. Desired results as follows; A B Red 1 Yellow 1 Green 1 Yellow 2 Blue 1 Red 2 Yellow...

Hi, I am creating a spreadsheet as follows; Sheet 1 - User entry form. Range A2:E10 have dependant drop down lists and a fixed set of headings in Cells G1-Z1. Lookup results will be displayed in Cells G2:Z10. Sheet 2 - Lookup database. VLOOKUP data in Range A2:E1000. HLOOKUP data in Range...

Thanks Narayan. Exactly what I wanted.

Thanks srinidhi. I was hoping to set up a template and use formulas rather than have to do a manual text to column each time I do this. If data (AB12.34) is in cell A1, I need formulas in cells B1, C1 and D1 to provide results "AB", "12" and "34" respectively. Hope this makes sense.