Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Copying formula to the next sheet and extend loop

    I have 151 sheets.

    Should have said link and not formula sorry. So by formula I meant a link to a cell of a sharepoint excel file.

    So the first one would be https//sharepoint.com/file1/cellA1
    ...
  2. Copying formula to the next sheet and extend loop

    I have a list of 150 formulas in Column B

    I want to put the formula in B1 on the second sheet and extend it from A1:H200

    Then I should grab the next formula in B2 and put in on the third sheet...
  3. Replies
    0
    Views
    23

    Turning 1 workbook link into a table

    I have 200 links to different workbooks that I need to turn into tables/data.

    =+'https://onedrive.com/Documents/[File1]Sheet1'!E1
    =+'https://onedrive.com/Documents/[File2]Sheet1'!E1...
  4. Re: Vba macro to open workbook and then activate the workbook from which the macro wss started

    Found the solution. Call this first then my other macro



    Sub OPEN1()
    Dim wb As Workbook, currentWb As Workbook
    Set currentWb = ThisWorkbook
    Set wb = Workbooks.Open("file")
    ' if...
  5. Vba macro to open workbook and then activate the workbook from which the macro wss started

    I have 1 macro that I use on different workbooks to pass data into a fixed workbook.

    So I want to be able to open that fixed workbook and then run my copying macro from the changing workbooks. The...
  6. Re: Macro to convert 1 row into multiple rows except for zeroes

    -Columns A:H

    -Columns F:H

    I managed to make it work but I literally tweaked everything until it worked. Still have trouble understanding why. Loops are no easy thing



    b(k,1) = a(i,2)...
  7. Re: Macro to convert 1 row into multiple rows except for zeroes

    That works beautifully. Thanks!

    I'm having trouble increasing the size of the array, any pointers? I want it to cover from column A to column. So as to copy more columns into the new sheet.


    ...
  8. Re: Macro to convert 1 row into multiple rows except for zeroes

    Entity
    Q1
    Q2
    Q3


    CompanyA
    40
    50.
    0
  9. Re: Macro to convert 1 row into multiple rows except for zeroes

    Thanks. I'll simplify.

    I have a worksheetsheet with 150 rows that have to be converted into 3 rows each based on if column B,C,D have a number or not. This has to go into another worksheet
    ...
  10. Macro to convert 1 row into multiple rows except for zeroes

    Hi guys here is the 2 macros I have for this issue. The first one transforms one row from into 4 different rows and the next one removes the rows that have a zero. This way seems to crude and I was...
  11. Re: Date formula with multiple conditions and nested ifs

    If theres no value it just says "Pending" which is good! Thanks :)
  12. Re: Date formula with multiple conditions and nested ifs

    Your formula works great K9, thanks a lot!!
  13. Re: Date formula with multiple conditions and nested ifs

    The new formula I have is:

    =If(A1=1,"complete",if(today()-c3<=5,"approaching",if(c3>today(),"Overdue","Pending")))

    Everything works except for the Overdue part, it gets stuck at approaching
  14. Date formula with multiple conditions and nested ifs

    Hi,

    I need a formula that tells me 4 options based on a date in C3:

    Overdue= the date has passed
    Approaching= date is 5 days away
    Pending= normal status
    Complete: if A1 is = Yes then...
  15. Replies
    11
    Views
    210

    Re: Combine 3 spreadsheets

    Its was very obvious. Sorry!

    It worked perfectly. Thanks!
  16. Replies
    11
    Views
    210

    Re: Combine 3 spreadsheets

    Oh its working now. But its copying from Column A to Column Q, how can I select which column to stop at?

    I'm trying to understand the code but it seems very high level
  17. Replies
    11
    Views
    210

    Re: Combine 3 spreadsheets

    Yes. I enter the names but it returns a object requiered error.

    On Sheet1.Range(a5:q5).Copy Sheets ("whatever").Range("a1")
  18. Replies
    11
    Views
    210

    Re: Combine 3 spreadsheets

    I think I need to keep studying. Can't figure it out

    The code asks me to input something and then it crashes saying object not found

    My data is in a1:b2 in every sheet
  19. Replies
    11
    Views
    210

    Re: Combine 3 spreadsheets

    Cant seem to make it work.

    I have 3 sheets. Sheet1, sheet2 and sheet3. I need to append all rows with data to a new spreadsheet
  20. Replies
    11
    Views
    210

    Re: Combine 3 spreadsheets

    I need to be able to pick the name of the spreadsheets that should be combined. So I do have a vba code that combines all but I want to be able to write the names of the ones I want
  21. Replies
    11
    Views
    210

    Combine 3 spreadsheets

    Hey!

    I need to combine 3 spreadsheets into a big one but I dont know how long each one will be. What I have so far is a short macro that merges them together and then deletes the blank rows...
  22. Re: Append table with another table and user input

    When running the Sql object I get an error of "Couldn't not find file \\user\account\Data.mdb

    Whats that about? :s
  23. Re: Append table with another table and user input

    Thank you! I will test this tomorrow :)

    Also how could I make it so that I can run the code based on a Month variable? Or do you have any pointer on where to look for the answer?
  24. Append table with another table and user input

    Hello guys,

    I have an issue which I assume is very simple yet I can't seem to figure it out. (Just started learning Access a few weeks ago)

    I have a table called Table1 with the following...
  25. Sum array then pasting it in another workbook

    The formula I have is the following:

    Inarr: Range("A1:J57")
    With Workbook("book.xlsx").Worksheet("All")
    loLastRow = .Cells(Rows.Count, 1).End(xlUp).Row + 1
    .Range("A") & loLastRow) inarr(43, 7)...
Results 1 to 25 of 32
Page 1 of 2 1 2