Recent content by xljgd

Hello All, I am trying to update data from main sheet "Status Summary" to the different tabs I have around 20 tabs and want to consolidated all sheets and update the formula for all sheets to update. I have eg. 3 projects 1, 2, 3 . Each have its own tab Project 1, Project 2, Project 3. on my...

Hello All, I am trying to update data from main sheet "Status Summary" to the different tabs I have around 20 tabs and want to consolidated all sheets and update the formula for all sheets to update. I have eg. 3 projects 1, 2, 3 . Each have its own tab Project 1, Project 2, Project 3. on my...

Thank you . That worked like a charm. i also got to learn something about Excel dereferencing. Do appreciate this forum continued support.

I do apologize for not being clear in my explanation. please find attached the file were i have worked out the problem. I had used sum since i had to sum 2 or 3 values in the array. The project name reads from another file. wanted to write the offset in a condition the criteria being...

I figured out the way to get the no after every 24 column. i am trying to a vlookup function were sum only if there is a match. can anyone help with the syntax. i have project nos in another file from A1 thru A50. A 5 2 0 0 0 0 0 0 5 2 0 3 0 0 0 eg if Project A is found in the file than...

I have data that is forecasted till year 2026. Based on the project match i need to sum the following roles for multi year. The data is filled for 24 columns and is distributed multi year. My project data is in another file so i try to match the data and if found selectively sum the following...

=SUM(OFFSET('2020 Project Load(Budgeted)'!C3,MATCH('Do No Modify! 2020 PL(Summary)'!C12,'2020 Project Load(Budgeted)'!C4:C143,0),976,1,1),OFFSET('2020 Project Load(Budgeted)'!C3,MATCH('Do No Modify! 2020 PL(Summary)'!C12,'2020 Project Load(Budgeted)'!C4:C143,0),982,1,2),OFFSET('2020 Project...

Thanks a ton. That was more that I could ever imagine like the search button etc. the last task I have is to pick pieces of information and create a running log. Each invoice value is broken into various costs that needs to be logged per invoice and the details to be transferred to an excel...

I am trying to open a word doc and read the table and transfer the contents in an excel. I am interested to get the first column of the table only that I the Task #. when I input this code and ran an F8 the file is being picked up but when it reaches the table Dim Tble As Integer the value is...

I have this code working but now I want the user to able to go the next and previous lines of record. once the user enters the values and hits the save button all values are filled in the worksheets were it needs to go to and than the data on the user form clears out. if the user made a single...

Works like a charm. Thanks for your input and your time.

I have a table with columns looking at another table. column h 444 -Task Error 210 210 electrical210 This looks at my table which the values 210 220 230 240 250 260 270 This formula looks at column H and takes out the first 3 letters and compares his value I another table. if match is...

Thank you for the code it worked like a charm. To include more values from text boxes i would define the no. say Resize (,5).Value and include one more item in my array. worked out great.

Thanks for your reply. sorry i did not explain myself very well. your formula includes count that is awesome. i want the values to sum based on Task no and sub total based on the category based on Material Travel and Expense. When the user interacts with the radio button the totals needs to...

Thanks Hui, It worked great. i had mis typed a sheet name and a txt field . Thanks for pointing it out. The next problem i have is selecting multiple checkboxes based on 2 conditions. In the data the user selects one check box and based on the number of checkboxes selected the data should be...