Search results

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...

=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...

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 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...

Hello All As you may have already guessed i am new to VBA coding. Below is a code were i am attempting to enter data in a user forma and copy it on a worksheet called InvDet. After i copy the lines i need to copy the lines into another excel sheet that is external to log this data in a...

Hello All, I have been checking all the posts and the VBA code and also used http://www.cpearson.com/excel/CFColors.htm codes from the above. But i dont think i am getting the desired results. Also since the code does not recalculate. how to call it from a button control to be able to...

Hi All, I am working with a spread sheet that needs a bit of automation and insight. I have team members who have forecasted their hours to work on a particular project thru the calendar year. The columns are spread out as weekends. this excel sheet is live and can be updated by the...

This is a very simple CF but i cannot get the logic. I have Eg Target date - 2011/3/21 Expected Date - 2011/4/31 cF rules i have applied if Expected Date < Target Date then fill green in the expected date if Expected Date > Target Date + 30 than fill red. that is if the...

I have a vlookup which changes values in the table based on the month. I have the month in the list box and the user selects it and the results change. I have 2 lists Current ap and previous ap. When the user select the current AP say May than the values change. i am having problems trying...

Hello All, I have a drop down list box that has say 1,2,3 values On selection A B c 1 3 a1*b1 3 1 a2*b2 2 1 a3*b3 The user has to select 3 option say high – red, med- yellow, low – green. Ideally I have to have a drop down box with the 3...

Hello All, I have 2 value that i select using a pull down. The number and the month. At each row if i select say no 1 and month May i should lookup the corresponding value. I have used vlookup to get values from the table for all other columns but not able to solve the value for the month...

Hello All, Can anyone help me with the formula to automatically autofill blanks in excel but in adjacent alternate rows. Eg Col A col B Name Dicipline Name1 Finance blank line Quality blank line Security Blank line Name 2 Security blank line Quality Blank line The intent...