Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rampure

    To display the content of the cell

    Hi, I am trying to display the contents of the cell based on a condition. I have a state column,store column, two retails column of two months, say Jan and feb and a change column. Now i am trying to display the state based on the change column. If there is no change in retail, display the...
  2. rampure

    Using Count function when the data is filtered

    Thank you Skip.
  3. rampure

    Using Count function when the data is filtered

    Hi, I have a huge data about 5000 rows. I have the filter on. Now I want to use the count and sum functions just for the filtered data and when I change the filter condition, the function should relect the change too. Thanks for your response in advance and I really appreciate the time. Smitha
  4. rampure

    Autofill - till data found

    Thank you so much PH. It works great. :) Smitha
  5. rampure

    Autofill - till data found

    I did use that code. But it still would fill in the cells with empty rows. Since I am checking for cells with empty rows, the X tend to fill in the D column. I want the autofill to stop when the empty row begins. Hope I am clear. Thanks again, Smitha
  6. rampure

    Autofill - till data found

    Sheets("GM TYLY").Select Columns("D:D").Insert Shift:=xlToRight Range("D5").FormulaR1C1 = _ "=IF(OR(RC[1]=0,RC[6]=0,RC[11]=0,RC[21]=0,RC[26]=0,RC[31]=0),""X"","""")" Range("D5").AutoFill Destination:=Intersect(Range("D5:D1000"), UsedRange) Calculate Thanks for your...
  7. rampure

    Autofill - till data found

    It gives me a run time error 424 and stops. When I tried to run the macro, it made me to remove . next to Range and UsedRange. Anyways, appreciate your response. Thanks, Smitha
  8. rampure

    Autofill - till data found

    .Range("D5").AutoFill Destination:=Intersect(.Range("D5:D1000"), .UsedRange) The macro stops at this line. THanks Smitha
  9. rampure

    Autofill - till data found

    PH, Thanks so much for your response. When I tried to use it, it gave me and "Object Required" error. I am so sorry for asking the basic questions but I am just a beginner. Should I be using just .UsedRange or something else to it? Thanks again. Smitha
  10. rampure

    Autofill - till data found

    Right now I am using this code. Sheets("GM TYLY").Select Columns("D:D").Select Selection.Insert Shift:=xlToRight Range("D5").Select ActiveCell.FormulaR1C1 = _ "=IF(OR(RC[1]=0,RC[6]=0,RC[11]=0,RC[21]=0,RC[26]=0,RC[31]=0),""X"","""")" Range("D5").Select...
  11. rampure

    Autofill - till data found

    Hi, I am using a couple of macros to automate in my spreadsheet. I need to copy the formula and fill the entire column till data is found. Right now, the macro is filling, but it is going beyond the data rows and filling in for the empty rows too. Can someone help me please. Thanks and...
  12. rampure

    Check a cell with a "X"

    Thank you all. I recorded a new macro with the formula and it works like a charm. Smitha
  13. rampure

    Check a cell with a "X"

    My apologies to all of you for not giving you the details. I am running a report on excel for products quarterly. So for every product I have data for 6 quarters. Now some of them might be discontinued, some of them new. I have a macro which calculates the formulas and sorts the data range...
  14. rampure

    Check a cell with a "X"

    I want the macro to check for the rows and make changes in the inserted column. I want to include this in the module that I have already created. And its not for 2 rows, more than 100 rows. Thank You. Smitha
  15. rampure

    Check a cell with a "X"

    Hi, This is my first day and first question here. I am trying to check a cell with a "X" if there is no data in the other cells. For example - if c5=0 or j5 = 0, then I want X in B5. I have this in the module. sub name() if(or(c5=0,j5=0),x,"") But this didn't work. Can someone help me with...
  16. rampure

    Check a cell with a "X"

    Thanks Skip and John. I did the same, but I want to do this with a macro. I will repost this in the forum John mentioned. Smitha
  17. rampure

    Check a cell with a "X"

    Hi, This is my first day and first question here. I am trying to check a cell with a "X" if there is no data in the other cells. For example - if c5=0 and j5 = 0, then I want Xin B5. Can someone help me with the steps? I am trying to write a module so it can be done automatically. Appreciate...

Part and Inventory Search

Back
Top