workbook and worksheets

Hi So, I have multiple workbooks (they are called: Human Resources, Science, Corporate Management, Public Affairs, .... I intend to add more). Each workbook has a sheet called: "Staffing-Processes". The data in each sheet has several rows (over 500 in some of them) I would like to be able to...

Hello, I am trying to trying to create a Macro to move information from my 'Export' file to my 'Yearly' file based off the worksheet name in the Yearly file. In the 1st screenshot below, I need to copy all rows and only column A to P, and then move these rows to the matching worksheets in...

Hi People, Can someone help me with below requirement. I have two workbooks(Wk1 and Wk2) with same headers and data. now i want to compare WK1(latest data) with WK2(old data) and add the lines of data to WK1 which is present in WK2 but not in WK1. to compare I can use column A in both sheets...

Hello, I would like to deny pasting into certain columns (F:G) without disrupting that ability elsewhere. I've searched for this and have come close to a solution, but they haven't been quite right. I used the following but it restricts pasting for the entire sheet Private Sub...

I'm trying to get workbook 1, all sheets used range, if cell value = a cell value in column a of sheets"Final" in Wb2. if so color cell indexcolor 6. the following cod runs but no color change. Sub color_matching_between_workbooks() Dim sh As Worksheet 'Dim wb1 As Workbook Dim wb2...

Hello Fellow Mr. Excel Users, Thank you in advance for any assistance or guidance you can offer. I am using Excel 2019 on the Office 365 platform. I have a master excel file that I would like broken out to separate workbooks, each containing specific worksheets, based on the data contained in...

Hello! My ultimate goal is to pull 3 types of information from n number of worksheets into a summary page. I was successful with copying and pasting unique values (see below), however, I am having issues copying one cell from each worksheet and having it repeat multiple times. I have multiple...

I am trying take copied data and paste it into another workbook with code. Here is what I am working with: Private Sub CommandButton1_Click() If TextBox1.Value = "" Or TextBox2.Value = "" Or TextBox3.Value = "" Then Exit Sub End If Range("H3") = TextBox1.Value Range("I3") =...

Hello everyone, i am in need of a little bit of help. I have searched google and many forums for pointers but do not seem to be able to find what I need. I have the vba code for looping through and copying columns of data from a "master workbook" with multiple sheets to a new workbook, but...