• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. X

    Automate data from main work sheet into different tabs

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

    Automatically get data from master sheet into work sheet tabs

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

    Offset function attempting to sum specific column in the array

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

    Offset function attempting to sum specific column in the array

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

    Offset function attempting to sum specific column in the array

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

    Offset function attempting to sum specific column in the array

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

    Offset function attempting to sum specific column in the array

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

    help with syntax error, subscript out of range, data transfer and checkbox control

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

    Transfer of data from word doc to excel tables are not being read

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

    help with syntax error, subscript out of range, data transfer and checkbox control

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

    vlookup mismatch between text and no

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

    vlookup mismatch between text and no

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

    help with syntax error, subscript out of range, data transfer and checkbox control

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

    help with syntax error, subscript out of range, data transfer and checkbox control

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

    help with syntax error, subscript out of range, data transfer and checkbox control

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

    help with syntax error, subscript out of range, data transfer and checkbox control

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

    count conditional formatted cells

    Hello All, I am quite honored that all of you have taken the time to help me out. Nayran latest vb reply was bang on target and that is what i wanted. VB is a new avenue and it is difficult for me to understand it but it is quite powerful. i will be trying the solutions listed by Chandoo and...
  18. X

    count conditional formatted cells

    Hello Narayan happy thanksgiving. please dont rush. have a relaxed day with your family. meanwhile i will also try to work out my solution based on Hui suggestions. do appreciate all your help and inputs and this forum has been a key helping tool to solve all my problems.
  19. X

    count conditional formatted cells

    Hello Naraynak, Thanks for the code. i checked it on a new set of data and it worked. i tried to play around with the code to get the numbers for non-colored cell but no success. i am very new to VB and my knowledge is limited to copying a piece of code and testing it. i have tried to read...
  20. X

    count conditional formatted cells

    Hello Narayank, Sorry i spoke to soon here. yes i did select the range but my count does not tally. see the attached xls sheet. Also right now you are calling the function via a pop up window alert is it possible to have this as line in the work sheet...
  21. X

    count conditional formatted cells

    Thanks Narayank and Dinesh. Your excel sheet always displays 0 when the button is pressed. i dont want to know what color the cell is but want to count all the cells were conditional formatting is applied. I have an excel sheet were i have set conditional formatting to cells that have...
  22. X

    Resource allocation spreadheet

    Thanks for both your replies i could go into the password protected option but i would be interested in trying out Faseeh solution. I dont understand it totally. I am not restricted to use a single sheet. if i have a forecasted dates master sheet how can i still only show dates in the future...
  23. X

    count conditional formatted cells

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

    Resource allocation spreadheet

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

    drop down on text and numeric based

    the paranthesis was the problem. i should have tested it more before i emailed to the forum. thanks again. appreciate your time, patience and help with this.
Back
Top