worksheet1

  1. T

    Copying via formula

    Hi, I have worksheet1 where I have a list of items and this is where I add, delete or amend the item details, I use conditional formatting to highlight certain things. In worksheet2 I use a formula to get the data from each cell in worksheet1 (=worksheet1!A1 etc for each cell). Then in...
  2. M

    VBA Index Match & Paste???

    Hi All, I've currently got 2 worksheets in a single workbook which interact with each other. Worksheet1 pulls data from worksheet2 by using an index match, but the problem I have with this is when the data is changed in worksheet 2 this then knocks on to worksheet1. I have the excel formulas...
  3. M

    vba function ThisCell.Address

    I have this function: Function student() student = Range("'" + Range("B1").Value + "student'!" + Application.ThisCell.Address).Value End Function I use this function in worksheet1. The value in B1 gives the name of another worksheet, let's say ws2. I need to pick up the value in that other...
  4. R

    VLOOKUP maybe? Search a row of text in one worksheet by comparing from another worksheet

    Hi, I have worksheet1 with rows that contain a sentence. In another worksheet2 I have a table with Keywords that I want to look up in worksheet1 and then redefine them with worksheet2 table. I thought perhaps it would be an IF with VLOOKUP, but I'm not getting the expected result. For...
  5. P

    VLOOKUP type question to copy part of a row once the value is hound in a range

    So I have values such as "SAW", "BP", "MILL", "LATHE" in the range of G2:O250 in WORKSHEET1. What I want to do is create a new worksheet tab called "SAW" & have it import the any row from A:O on WORKSHEET1 that has that has the cell value of "SAW"in it. This will basically show me all jobs...
  6. N

    Track number from a list and copy paste the value's

    Hi Guys! Excel is giving me a hard time. I hope you guys could help me find a solution. I have a grocery list like in the picture below in Worksheet1. The one below is simplified but actually it exists out of 1000 numbers with different discription, units and amounts. The worksheet1 one...
  7. S

    Deleting specific cells when a condition is no longer met

    Hello, I have this coding below, which works really well, by automatically copying and pasting specific cells from worksheet1 onto worksheet2 when specific words are chosen in worksheet1 cell L from a drop down menu. The problem I have is that once the cells are pasted onto worksheet2, they...
  8. S

    Automatically copy certain cells from rows from one Worksheet into another Worksheet in the same Workbook if a condition is met in certain cell

    Hi, I'm new here. I used to do a little of vba in excel a few years back but I find myself a bit rusty now. I've been given a task that I'm finding a bit difficult and hope you can help. I have a Workbook with several Worksheets (3 Worksheets) Worksheet1 will be just for entering data in...
  9. N

    Get closest value for nearest date

    From the below. worksheet1 : In worksheet1 "duty" column. I need to find out what duty "worker" last had during work_order_date. Bill on work_order_date 08/01/2017 & 08/05/2017 should report back as "welder" because he was not yet a manager until 8/15/2017. worksheet1 Bill work_order_date...
  10. J

    VLOOKUP and MIN functions

    Example worksheets: I'm trying to resolve for Worksheet1 B2 - B4 I want to find the earliest transaction date in Worksheet2 for each UniqueID in Worksheet1 Column A and place the date in Worksheet1 Column B. There are only unique ID numbers in A Worksheet 1 Worksheet2 is a transaction table...
  11. J

    I have 3 spreadsheets that I want to merge into 1

    I have 3 spreadsheet with worksheet1 containing data in each spreadsheet. How can I copy all the cells from each of the and put them all in worksheet1 in another spreadsheet.

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