Search:

Type: Posts; User: jwburritt; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    150

    Re: Loop and Long Formula

    Thank you everyone. I used the shortened formula from njimack as a base. That made the debugging much easer. I had also forgotten the "" around ""c"".

    This now works:

    .Formula = "=" & VCell(i,...
  2. Replies
    5
    Views
    150

    Re: Loop and Long Formula

    Thanks. Below is the original formula along with the vba version that I'm trying to loop with the a variable. I can't get the looping version to work.

    Dim VSh As Worksheet
    Set VSh =...
  3. Replies
    5
    Views
    150

    Loop and Long Formula

    Hello: I have a loop that is filling in formulas based on a cell value. The formula for "A" is fairly simple and is included in the code as a formula. But the one for "AB" has a lot of nested ifs and...
  4. Replies
    5
    Views
    127

    Re: Referencing table in another workbook

    Thanks again. This syntax ended up working...


    .Formula = "=INDEX('[Other Workbook.xlsm]Data'!data_table[Account Type],MATCH(CurrentSheet!" & Cells(i, 6) _
    .Address(0, 0) &...
  5. Replies
    5
    Views
    127

    Re: Referencing table in another workbook

    Thank you, but that didn't work: syntax error.
  6. Replies
    5
    Views
    127

    Re: Referencing table in another workbook

    Any help with this would be appreciated. I'm still stuck.
  7. Replies
    5
    Views
    127

    Referencing table in another workbook

    Hello: I have a formula in a CurrentSheet that is looping through data looking at the headers of a data table (data_table) in the same workbook for index and match. That code works fine and is below....
  8. Replies
    5
    Views
    75

    Re: Cleaning up records

    Thank you!
  9. Replies
    5
    Views
    75

    Re: Cleaning up records

    Thank you. I thought of that earlier, but the sheet I'm manipulating the raw data in is only temporary. Once the data is cleaned and formulated properly, I'll copy all the data to the target sheet...
  10. Replies
    5
    Views
    75

    Cleaning up records

    Hello: I have part of a macro that needs to clean up cells and replace the bad data with the good data. I'm using a loop nested if else, but is there a more efficient way? This looks cumbersome. Any...
  11. Replies
    2
    Views
    82

    Re: Index Match formula Loop

    duh! Thanks Mark!
  12. Replies
    2
    Views
    82

    Index Match formula Loop

    Hello: I have the following formula that I need to replicate down a column. When I paste it, it works fine. But when I try to put it into a loop, I can't seem to make it work. The failing loop is...
  13. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Great, Dante. Works perfectly!
  14. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Thanks again. Works great...until I try to move it. I'm going to be moving columns around in the table and move the table itself in the sheet. So, I need to be able to adjust the code. Normally, this...
  15. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Thank you! I'll check it out asap.
  16. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Hello again: I just discovered that the address of the cell reference above needs to also return a structured table address so when I dump the data into the table, the formulas match. In the target...
  17. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Thank you Dante! :cool:
  18. Thread: Date loop

    by jwburritt
    Replies
    5
    Views
    120

    Re: Date loop

    Thank you Dante! :cool:
  19. Thread: Date loop

    by jwburritt
    Replies
    5
    Views
    120

    Date loop

    Hello: I need a sub to input last month's date into a column of data and then hard code the date. The only solution I came up with is below, but I'm wondering why it's not creating a circular...
  20. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Thanks, Dante. Works fine. But, it produces absolute cell references. I need relative because it's going to get thrown into a table with existing data. Possible? I've tried everything and can't make...
  21. Replies
    14
    Views
    431

    Re: Loop through data and create formulas

    Thanks so much. Hadn't thought of that! But it's part of a much larger sheet. And depending on in which column the data sits, the formula as to change. Here's an example. The data in col B needs to...
  22. Replies
    14
    Views
    431

    Loop through data and create formulas

    Hello: I have the following data. I want col A to equal the value of the first cell to its right, but retain it in a formula. For example the successful result in A2 would be "=B2" not "1". The...
  23. Replies
    5
    Views
    108

    Re: Looping through Data

    Works great. Just had to move the data down so the first column begins at A2 and the counter begins at 2. Otherwise this line

    Cells(i, "C").Value = Cells(i - 1, "C").Value
    would throw a 1004...
  24. Replies
    5
    Views
    108

    Re: Looping through Data

    Thanks. Works great!
  25. Replies
    5
    Views
    108

    Looping through Data

    Hi: I have data in col A and B. I'd like to build a macro that, if it finds the term "trigger" in col A, it copies the data in col B to col C (all in the same row). But, if it doesn't find the term...
Results 1 to 25 of 46
Page 1 of 2 1 2