transfer data to sheets

Private Sub cmdClose_Click() End End Sub Private Sub cmdSubmit_Click() 'Priority Options If Pri1.Value = "True" Then Worksheets("Procedures").Cells(lastrow + 1, 2).Value = Pri1.Caption End If If Pri2.Value = "True" Then...

I have no experience of excel formulas but want to create one for work with information moving to a 2nd sheet if its been on for over two weeks, so that we still have information surrounding it. Can anybody please help me with this? Information Date Bla bla bla 03.03.2023

Greetings everyone. I would like to request some assistance on how to transfer Samples 1-5 userform values to their respective cells. I can only do a simple "If-Then" although I have a month's worth of data it would make the code somewhat long. Maybe there's a code that can transfer based on...

I have a blank workbook with two sheets that Excel created, originally called 'Sheet1' and 'Sheet2'. Then I renamed these to be called 'TEST1' (formally Sheet1) and 'TEST2' (formally Sheet2). I have a number in TEST1 cell 'A1' that I need to copy over to TEST2 cell 'A1'. In Sheet2 cell 'A1' I...

Hi I need to transfer quote a lot of data from one worksheet to another. The data I need is all in column L, but I need to first check the following: A in the target sheet needs to match B in the source - this is simply a date in dd/mm/yyyy format AA in the target sheet needs to match I in the...

Hi I am new to VBA for excel and I am trying to transfer a data from master sheet which contains expenses for different dates and for every date I have a separate sheet where I want to transfer expenses from master sheet named "Data Entry". the problem with my code is that when I transfer...

Hi I have created a VBA excel form which pre populates a number of text boxes based on an excel file . As well as the Textboxes there are a number of comboboxes. The data that is generated from the excel file is based on a user selecting an email address so the number of rows changes each...

Hello, I am hoping someone could help teach me how to transfer data by columns from one sheet to another. Essentially, the headers on both sheets will be the same. However, the order of information on sheet 1 is never the same as the set order on sheet 2. I was wondering what is the best way to...

I am using code to transfer data that don't have a blank cell in column A from "Data" to "ForIndustry". While the code works, I would like to only transfer columns A:P rather than the whole row. Any guidance would be much appreciated. Sub transfer() Set i = Sheets("Data") Set e =...

Good morning. I will try and explain this as thoroughly as possible. I have a sheet with Dates as rows and test locations as columns (just fyi...there are about 275 columns of testing points). It is conditionally formatted so anything out of control gets highlighted in red as seen on 6/5. Please...

I apologize in advance if this has been covered in a previous post... I have a couple hundred pages of trend data (in notepad) and I would like to move it into Excel. However, at each page break there is an automated message/header repeated. I do not want this information to come over. I...

Hi all! I'm working on a shared tracker with Contact details, dates and more information and it gets updated every day from different people and every time they update or input new data, they are obligated to change its font to red. When I see the new updates, I consolidate this information...

Hi, I am very new in the use of excel vba and require some advice. My source data is a master spreadsheet that has column A to I filled with information. All subsequent workbooks will have the same headers. My queries is in 2 parts. Part 1 The master spreadsheet contains the workload of a...

I have a list of appliances with several columns, but two of the columns have pricing information, I would prefer to transfer to another workbook. If this is not possible, then transfer to another worksheet. My first Excel Workbook is called RetailDeck. The second Workbook is called...

Hello all, I am after some help with excel. I am a PE teacher and need to find a way to cut down the processing time for our athletics carnival scoring system. One way is to use excel to automatically sort through some of the data for me. The problem is Im not savvy enough to set this up and...

Hi guys, The code I've been using doesn't give me the results I want. Basically, I want it to copy-paste the two selections (which contains functions and graphs) to another Excel file (paste values and graphs). When it sends the data to the other file, I want it to create a new sheet based on...

Hi Guys, I need to transfer a row of data from "sheet1" for example B11:P11 to another sheet in the work book. The data in column B11:B170 will define sheet names. So the macro can use this to reference which sheet the row of data needs transferring to. The row of data also need to go into the...

I have my userform set up with all the combo boxes. One of the Combo boxes(NamesDropDown) includes the names of all the students. As stated above each of the 6 combo boxes has the list of courses. I also have other text boxes in the same userform that will collect grades. What I need is that...

ILLUSTRATIVE EXAMPLE OF WHAT I’M ASKING: I have two spreadsheets, Sheet1 (source sheet) and Sheet2 (target sheet). Sheet1 has data with corresponds to each of the 365 days of the year. Sheet2 desires to reproduce portions of Sheet1 data based on a common “peg” or reference value. In short, I...

-breakdown sheet PIC View image: Shift Breakdown - Schedule sheet PIC View image: Schedule Sheet hope someone can help me, I manage schedules in my job, but with a lot of employees, takes a lot of my time... Currently I have a schedule sheet and a breakdown sheet... Each day I look...