two sheets

  1. E

    VBA - Generate Serial Number max in two sheets

    Hi guys, have serial numbers with data in row in two different sheets (from main sheet divided later to two different, according the data in row). can someone help with a code to generate serial number after checking what is the max in the whole workbook? i am currently using +1 on the last row...
  2. J

    Help with VBA If/then statement match cells in same row in two columns on two different sheets then copy next cell from sheet 2 to sheet 1.

    I need help with a VBA script for Excel. I've tried modifying several I found on line but, none have worked for what I need. I need to create a VBA script, i assume with an If/then statement. I need to look at columns B and C in Sheet 1 for matching cells in columns B and C in Sheet 2. The two...
  3. O

    VBA Lookup from 2 different tables (in different sheets from a single workbook) to make logical conclusion and print result in cell

    Hello, I have quite a challenge here .. I am trying to lookup multiple values from 2 different tables from different sheets in a single workbook (different from the one I am applying VBA to) I wrote this code from scratch but the from so I apologize in advance for the obvious errors or...
  4. G

    Mirroring columns to two different sheets

    Hi guys.. my very first post to this site What I am trying to do here is making a two way input range in two different sheets That is, if I put anything in "A:A" Column(or specific range) in sheet1, it will appear on sheet2 "C:C" column(or specific range). Also, if I revise it on Sheet2 range...
  5. C

    conditional formatting dilemma!

    Hi, I was wondering if anybody could help me on here, I have scoured the Internet for solutions but none quite solve my problem. I use a 2007 excel sheet to book products in and out of work. There are two sheets in the workbook, sheet one for booked in and sheet two for booked out. As I book...
  6. W

    search options

    is there a formula that would allow me to search a whole sheet from another sheet given 2 options but only one needs to be filled in. such as you could either searh by their last name or by their special code and the search will pull up the same information??? i currently have a vlookup formula...
  7. J

    Multiple formulas on sheet 1 referencing data on sheet 2

    Hello, Let's pretend I had sheet 1 and sheet 2. Sheet 1 has multiple formulas, sum(), average(), etc. Now the data is on sheet two. Each formula points to product 1, 2, 3. So on sheet 2, product 1, 2, 3 have one data in the column. So I need the formulas on sheet 1 to reference sheet 2. I was...
  8. MaxWol

    Remove different rows in 2 sheets

    Hi all, I have two sheets. Sheet 1 has 73.619 rows and sheet 2 has 41.470 rows. The values of column A in sheet 2 appear randomly in column A of sheet 1. I want to do 2 things: 1. I want to delete all rows in sheet 1 that have a value in column A that can not be found in column A of sheet...
  9. P

    Copying column data from one sheet to another

    Hi all I am new to Macros and I need a little help with a project I have just been given. I have two sheets in an Excel workbook. One has the information in column D starting in cell D2 in my 'source' sheet. I want to be able to copy all the entries in that column to another sheet called...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top