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 Chris Miller 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: *

  • Users: managementOptions
  • Order by date
  1. managementOptions

    Setting a worksheet to a variable

    This is an excel macro and I just cannot get one variable to set a value. I have rem'd out most of the lines of the below trying to eliminate any other issues that could cause the problem. I am trying to set two variables as worksheets (Ws1 and Ws2) to excel files. And eventually I want to...
  2. managementOptions

    Code use a row number in a variable

    I need to get user input to determine what row to copy from a large group of data to a specific row near the top of the spreadsheet. My thought is to have the user enter the row number they want copied into cell A3. And then that row number would be copied into row 4. So, if the user enters...
  3. managementOptions

    Assigned cell contents to a variable & using the var in cell reference

    In this particular task I have many rows of data and want to let the user select a row to bring to the top. Not move the row, just copy it into a blank row near the top of the spreadsheet. First assume: The data begins in row 10 and extends down to whatever length. Row 3 is used for no other...
  4. managementOptions

    Use contents of one cell as part of formula elsewhere

    In this particular task I have many rows of data and want to let the user select a row to bring to the top. Not move the row, just copy it into a blank row near the top of the spreadsheet. First assume: The data begins in row 10 and extends down to whatever length. Row 3 is used for no other...
  5. managementOptions

    Copy a formula from 1 spreadsheet to another, preferable with a macro

    I need to take a number of steps after this one. This is the only part that is an issue. I just want to copy the formulas into a spreadsheet via a macro. I cannot seem to make it work by just typing the text of the formula into the macro, as in "Macro Text to be entered" ... Or by copying...
  6. managementOptions

    Copy a formula from 1 spreadsheet to another, preferable with a macro

    First the goal. I have data that is downloaded into a spreadsheet. It comes in the form of a question and answer in text format which I then open in Excel. The lines read much like the two following lines. Name: Robert Volume: $10,000.00 Of course there are more entries with data of many...
  7. managementOptions

    Outlook autofill addresses

    Beginning with the 2007 version of Outlook, names could be sorted into folders. Once these folders are used, the autofill no longer works for any of those people. It seems that the only thing that makes it work correctly is to have all those people in one large folder. Is there any way to...

Part and Inventory Search

Back
Top