worksheet1

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.