sheet3

  1. S

    Excel VBA to cross match 2 sheets data and output into sheet3

    Hi Friends, Trying to match 2 sheets data and copy entire rows into sheet3 I been through posts on this mrexcel forum and on google search but did not find a correct vba to do the task. In sheet1 ColumnB is always blank In sheet2 ColumnE is always blank I manually copied what results should...
  2. G

    Lookup Subject to Conditions

    Hi, In A2:A1000 in Sheet1 I have series of consecutive month-end dates (31/07/2012, 31/08/2012 etc). In A2:A700 in Sheet2 I have a series of consecutive month-end dates and in B2:B700 the associated monthly sales values. In A2:A700 in Sheet3 I have a series of consecutive month-end dates...
  3. J

    Use VLookup in VBA

    Can I use vlookup to search values and ranges and two sheets and return results to a blank sheet (Sheet3)? For example, sheet2 has a value in B2. Sheet1 has the same value in E2, but I want to return the value in A2 to sheet3. I want to do this is vba. If possible, any suggestions to get me...
  4. D

    Transfer multiple Userform Textbox value to cells/columns

    Hi.. I have this code below that transfer my "Textbox1" to "Textbox20" to column A. I have another set of Textboxes ("DataBox1" to "Databox20") that i need to transfer to Column B. can anyone help me on this. Thanks Dim lrow As Long, i As Long lrow = Cells(Rows.Count, "A").End(xlUp).Row +...
  5. R

    rename specific worksheets

    Hi - everyday i always have 3 sheet (sheet1, sheet2 and sheet3) and need to copy to new workbook. but before that, i need to rename it with - sheet1 = backlog approval - sheet2 = backlog release - sheet3 = backlog pr instead using manual effort, can you please help to create vba macro to run...
  6. N

    Application.Match then Compare Dates from Offset Cells

    Help! Please! I have 3 sheets but only working through Sheet2 and Sheet3 for this code. The Sheet3 contains raw data that I want to validate against Sheet2, which has valid values. So basically go row by row through Sheet3 and compare the value from the identified cell against all data in the...
  7. I

    Lots of sheets

    Hi folks! I just created an account, because i need some help. I have lots of excel sheets. All are linked together. It is just a mess. So i am trying to visualize the flow of data through all sheets. I already made a table with all sheets and all dependencies. It looks like as follow...
  8. J

    If data is in between or equal to 2 dates, display a number

    Sheet1: <tbody> Block 1 Block 2 Block 3 2019-05-20 2019-05-23 2019-05-27 2019-05-22 2019-05-26 2019-05-31 </tbody> Sheet2: <tbody> 24 Cat 2019-05-21 25 Dog 2019-05-27 26 Bird 2019-05-24 </tbody> ** In column B, I used data validation to create a list: 1, 2, 3 Sheet1 defines...
  9. H

    Help with mutliple Worksheets copy and save as

    Hi All, Last question to finish my recent project :D I need to perform the following functions: - Copy Sheet2, Sheet3 and Sheet 4 to new workbook (using codename as sheet name change weekly) - Hide Sheet2 - Save workbook in original directory taking Sheet2 name and fixed suffix -...
  10. G

    VBA to Extract Unique Values Across Multiple Sheets into One Sheet

    Hi Experts! Here's my current situation, I have 3 different worksheets. Let's call them: Sheet1, Sheet2, Sheet3. - Sheet1 contains New Data that is delivered daily. - Sheet2 contains Old Data. - Sheet3 is meant to dump non duplicate values between Sheet1 and Sheet2. Example : Sheet1 contain ...
  11. jim may

    Working With A New Window in Excel

    What I've been trying to do might not be possible, but I'll ask anyway... In my File on a Given Worksheet named "Main" - I clicked on View - New Window So Now I have MyFileName.xlsm:1 and also (now, not before) MyFileName.xlsm:2. Originally on my Main Sheet (Now +":1")- I had Sheet1, Sheet2...
  12. F

    Pass array of sheet names to another procedure

    In lieu of placing the array of sheets within the two procedures below, how can I use a third procedure to establish the array of sheets and then pass that argument? Sub ApplyAutofilter() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets(Array("Sheet1", "Sheet2", "Sheet3"...
  13. Trevor3007

    print pdf with tab as file name

    hi, is it possible to print the in sheet1 , sheet3 & sheet2 (in that order) save as their tab names to the following locations:- sheet1 = c:\data (print area is A1:I23 sheet3 = c:\data2 (print area is A1:O15 sheet2 = c:\data3 (print area is A1:H22) and print each as a PDF? Please can...
  14. How_Do_I

    Formula Help

    Hello, I'm interested in the last digit of the string... If it's a "." or a ";" I need that removing, if it's not a "." or a ";" then I want one cell to the left... So, what formula would I place in C2 so that all my returns are "Assistance to Finland" please... Sheet3 <colgroup><col...
  15. R

    SumIf + Vlookup

    Hello , Could you please help me with one excel formula? I am trying to have dynamic sum range, where the sum range column changed based on cell value Below you can find the formula which I am trying to build: Sheet1 : D1="23%" A1="BE"...
  16. C

    Search value the prompt for user form with three options, place in cell afterwards

    Hi, I want to click macro. it searches sheet3 A:A for a value. If it doesnt find it, message just says value not present. If it finds it, it pulls up a userform named "goahead", it consists of three choices yes, no, n/a. whichever one is selected, it places that in sheet3 column z for that...
  17. C

    3D Sumproduct not working

    Hi everyone, I have multiple worksheets (Sheet2, Sheet3, etc.) with values in columns B and C that I want to summarise in Sheet1. I am trying to use a 3D sumproduct function, but it is not working - I'm just getting the #VALUE ! error. I don't have a coding background and have tried cobbling...
  18. B

    Generate ID Number to textbox in userform

    Hi all, Very new to all this - I'm an old dog trying to learn new tricks. I have created a userform with textbox's and combobox's along with a save button. When you press the save button, all the entered data does what it is meant to do - sent to sheet3 (info) and then resets the form for the...
  19. corppunishment11

    Multiple if(or) or maybe I need if(and) Can I make this work?

    I've written nesting if(ands) but I'm wondering if I can have an If(or do what I want it to. I'm looking to have one formula look at a set cell position A2 on sheet 1 "Bob Builder" and then compare that to sheet3 A2:A1000. If it's "Bob Builder" then return the values in sheet3 B2:B1000. But I...
  20. N

    array compare

    Hi guys I have a question/task if you can help me with please + explanation :smile: I will really appreciate it. I have two columns in two sheets (4 columns). Basically what i want to do is to compare between the concatenation of the two columns in each sheets. So compare A2&B2 in sheet 1...

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