sheet2

Hi Guys! I have been looking around for some advice on how to do this, and it seams to be more complicated than I anticipated. So far I have only found a way to do the opposite of what I am after and cannot figure out how to reverse it. My problem: I have a range of values in cell D1:N1 in...

Hi please can you help I have a command button1 with s list for example: shop, car, home. If home is selected then what I type into the text box I want this copied into sheet2 A2:A5. If car is selected I want the text in the textbox copied into sheet2 B2:B5 hope this makes sense please can you...

Hello Everyone, have a quick question about adding onto the formula below. Sheet1 H5=IFEROR(INDEX(Sheet2!$AK$3:$AK$13,MATCH($B5,Sheet2!$A$3:$A13,0)),"") To have it process the below? In sheet 2 Column A is a list of companies and AK2 = Total of errors for each of the companies AL2 =...

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

Hi Team, I need some help, I have 7 columns data in sheet1 and this is the reference of original data from Sheet2 (through the formula) both data sets are same. I am not sure if this can be done via worksheet change request. If I change the cell value in any rows then that entire row till...

Hi all, I want to make a "simple" maintenance plan that can do following tasks: to check when opened if the planned maintenance week has passed or is this week on sheet2 column BG, and if the maintenance to specific machine number was not done (columns BK, BM, BO and BQ) and display the results...

Hi all i need your support, i want to tranfer data from one sheet to another sheet through button, please see the snap only yellow highlighted items are transferred to another sheet. sheet2 result like this.

I have 2 sheets, sheet1 and sheet2. In sheet1 I have data that I will manually be moving up or down monthly. In sheet2 I need it to copy the contents of a specified cell. The problem is that when I move the row in sheet1 the information in sheet2 follows the cell. Ex. Sheet1 cell a1=x and cell...

Is there something in vba excel to update sheet2 from a search with the value from the sheet1 from after been updated. For example Sheet 1 <tbody> Customer 1 Time In: 1:00 Customer 2 Time In: Customer 3 Time In: 14:00 Customer 4 Time In: Customer 5 Time In...

Hi all, i using a formula Hlookup(C5,VL,A7,FALSE) is not working. can anybody tell me why? i use this sheet2 d8 cell. VL is the range of sheet1 d4 to s65. i want to change date c5 in sheet2 data pick AUTO from sheet1 as mention in sheet2 C8. Sheet1, sheet2,

Hi! I'm need of abit of help here. Prob taken water over my head. I'm a really green VBA coder. Been trying to google and youtube for solutions to my problem. Right now I am doing this manualy with abit of coding. But was wondering if there might be a fully automated solution to this. My...

I've been looking at a few different ways of doing this, hoping someone could possibly shed some light on what may be the easiest way. I'm trying to build a schedule for my offices equipment that goes out into the field (We have about 70 or so pieces of gear to log). Gear to be listed down the...

If data in sheet1 column Y and sheet 2 column A + the data in sheet1 column AA and sheet 24 column C match, then copy sheet2 Column B.

Greetings everyone, I'm trying to populate ListBox1 on my user form with the information in columns A and B from different sheets. For this I have a ComboBox1 containing the names of all sheets in the workbook. For instance, my ComboBox loads "Sheet1", "Sheet2", etc. I want to, upon changing...

Hello, I have 2 sheets: sheet 1 & sheet2. On Sheet 1 I want to reference the value from sheet2 (A2 - only). On Sheet2 I take the data from an address (Data -> From Web, import) and It gives a number. That number I want to be on Sheet1 - A1 (for example). When I reference: "=Sum(Sheet2!A2)"...

Hello My Masters & Colleagues, I have 3 columns of data in sheet2 (A) for Branches (B) for Departments and (C) for Names A2:c5000 like the table below the 3 lists are related and has some duplicates and blanks. And I have 3 Columns lets say J,K,L in sheet1 I want to J2:J each cell is validation...

Hi all, Im trying to figure out the best way to do this and hoping someone could point me in the right direction. Sheet1 - Employees data Sheet2 - Log Sheet2 - Log - Column A is for the employee number. When the user inputs the employee number it pulls through the employee details from the...

Sheet1 is vendor number and vendor name. Vendor name takes the form of a hyperlink formula that links to their homepage. (i.e. so the text that displays is Microsoft but if you were to actually click it, it takes you to microsoft dot com) Sheet2 contains the vendor number. The goal is to do a...

Hi I have a book with two sheets sheet 1 and sheet2 In sheet2 i have a data validation dropdown list created based on data from sheet1 When user are in sheet1 i want the user to be able to click on a value (that is part of the dropdown list on sheet2) and then go to sheet2 and have the...

Hi, I have a worksheet (Sheet1) with data in each row. I want the data in Sheet1 to be transferred to sheet2 if column 10 (J) equals "Yes", and once transferred/copied to sheet2, the data is deleted from sheet1 and the all the blank rows are deleted. Column 10 value will be either Yes or No. Any...