specific cells

  1. E

    Copy and Paste specific data vba code

    In the below code I am trying to look through my data for a specific name and then cut that data and paste it into a specific cell but I am getting an error on the last line. the error states: runtime error 438 object doesn't support this property or method. Can anyone help me see what I am...
  2. L

    AutoSave using specific cell(s) to rename and to a specific location

    Noob to VBA here, apologies in advance. Haven't even thought of macros in years, and searched the forum and can't quite piece together the parts to what I need. I have a spreadsheet for daily jobsite use...completed by the crew and used by internal departments for payroll and billing. Boss is...
  3. W

    Insert a row with specific contents after every merged data cell.....

    Hi all I've looked online for VBA code to insert a row with specific contents (ex. 'Example1' after every merged data cell (it should check for data) in a specified range (B13:B269), but none seem to work properly with the merged cells. Column B has merged cells, but column D does not (Column C...
  4. S

    Look up particular row information if cell value matches specified value

    Hi all :) I have two worksheets, one named Data and one named Index. In column G of Data, there is an index number. In column G of Index, there is a list of special index numbers. In columns A:F there is information about each special index numbers. What I need is in Data, if the index number...
  5. S

    Only keep rows that have a range of specified values in a particular column

    Hi all :) I have a dataset with 34 columns and ~5000 rows. In column G there is an index number. The index number goes down the column, increasing by 1 each time, eg in G2 the index is 1, in G3 the index is 2, in G4 the index is 3. . . Data worksheet <tbody> Columns A, B, C, D, E, F G -...
  6. C

    Browser URI to open Excel at a specific Cell

    Hi all Is it possible to create a browser URI to open a excel workbook at a specific cell? Thanks in advance Michael
  7. A

    Search specific text and past in specified cell

    Hi, Any help is appreciated on this query. I have a sentence in column C (Sheet1) and I need to search a specific text which is placed in Sheet2 Column A1 till A100. I am trying to check if Sheet1 Column C has the text from Sheet2 Column A and place that text in Sheet1 Column E. For...
  8. sir_smee

    Excluding specific cells from printing

    Dear Excel gurus, Background: I have a single-page sheet I use for cash-up purposes, upon which I have added a short sentence explaining to my staff which buttons to press to run a macro.:confused: Question: How can I exclude this instruction from printing when they print their reports?
  9. M

    Extra data (specific cells) from various close workbook

    I am pretty new with VBA - am actually an accountant. But help is needed. As the subject says, I need data from specific cells of various cloded workbooks and the data have to show a a summary sheet at various specific cells. ie. data from A2 (closed workbook 1) must show in C3 (in another...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top