workbook and worksheets

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

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