between worksheets

  1. D

    VBA to replace index matching.

    Hi Folks, I am looking for a way using VBA to do the following process: I have two worksheets: Sheet 1 (contains Table 1) and Sheet 2 (contains table 2). Worksheet 1: Table 1 - Column A contains serial numbers. Worksheet 2: Table 2 - Column A contains an index of all the serial...
  2. M

    filter one worksheet based on formulas from another worksheet

    Hi. My situation is this: Every week, I get a worksheet full of data. Some rows are relevant to me, and some are not. My goal is to quickly create a list of only the relevant rows. (I send this list on to others who are not interested in the process, so for the final product, I don't want it to...
  3. HawaiianShirts

    How to Find a Value if a Date Includes a Referenced Month

    I did some research and wrote out what I thought was a working formula, but it returned a zero. That's not what I was after. To set the stage... Worksheet 1 includes lots of data points. The relevant ones are dates (Column A), descriptions (Column D) and dollar amounts (Column F). Worksheet 2...
  4. B

    Copying formatting of cells between worksheets

    Hi There, I'm trying to copy formatting from a range of cells to a range of cells on another work sheet that will automatically update when the first one is changed. I found the below thread and tried to use the VBA scripts in it but to no avail...
  5. B

    Copy Rows between sheets

    I have worksheet1, worksheet2 and worksheet3 and I am trying to have excel do a compare of a cell in worksheet3 against a cell in worksheet2 and if a match is found copy the entire row of worksheet2 to worksheet1. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office"...
  6. C

    Linking All Applicable Data To Defined Range From One Worksheet to Another

    I am using an advanced filter to find all employees (from a master scheduling workbook) not available to work on a given workday. It is then pasted into a sheet in the weekly schedule. Is it possible to link this data in some way from that worksheet to another worksheet - daily schedule - to...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top