ws2

I'm using this code to filter a list on ws2 based on lists on ws1. I have 10 lists each with different variables. I want to be able to put a validation list in a cell on ws2 with the names of each list on ws1. This input would then be used to define "Ary" below. Is this just a matter of...

Hi guys, Hopefully an easy one – I often struggle withtroubleshooting the lookup function of excel. I have a workbook with two worksheets: Employee details (WS1) Bank deposits (WS2) Each month, I need to paste in bank deposit information intoWS2. I would like to be able to...

Experts - What is the best way to declare DIM variables. I'm running a script which bounces between a couple Excel books and several Sheets & Ranges. With memory preservation in mind, Is the best way to declare these variables with as few DIM statements as possible, then set, clear (set to...

Sub Concate() Dim i As Long Dim c As String Dim WS1 As Worksheet Dim WS2 As Worksheet Set WS1 = Worksheets("BEFORE AND AFTER") Set WS2 = Worksheets("COMPARE") For i = 4 To 10004 WS2.Cells(i, 123) = WS1.Cells(i, 188) & " " & WS1.Cells(i, 189) c =...

I am currently getting an error when I run this on the "Next i" section. If I change it to "Next" and remove the "i", then I don't get an error, but it loops the "i", but not the "i" I am trying to concatenate 2 cells from one sheet and move them into another on a separate sheet Sub...

So I re-thought my Userform data transfer to the worksheet. I previously had a workbook that would save my "quotes" and move all the info over to the register and would change the quote number as it was saved. It would count up by one on "Quote" worksheet so the every time the worksheet saved...

Hello Friends! One of our Moderators - Fluff - is providing Dictinaries which speeds up everything beyond expectations. Can You make for me a macro that will compare colums A,E,G and remove duplicates in this fashion? ex. IF A5, E5, G5 has the same values as A54321, E54321, G54321 and A99...

Hi all, I have a code which adds two new sheets ws2 and ws3 by the following script Dim ws2 As Worksheet: Set ws2 = Sheets.Add and it works fine. I wrote a macro which adds all sort of formulas in both ws2 and ws3 But when I wanted to add formula to ws3 looking up values in ws2, the...

Hello, I have a problem with some find, copy and paste coding. On a userform, there is a listbox for the academic year (acad_year) and a textbox for the unique record id (id) which supplies the two variables for this part of the coding. Both of these are working correctly and storing the...

I'm trying to update two different sheets, where a value in each sheet matches the value of a textbox. The code below, works fine until I try to incorporate the ws2 stuff highlighted in red. Can someone advise how I need to change the code to accomplish the goal? Private Sub...

I have been at this now for days now trying everything i can find and adapting it. I want to copy data from one sheet to another at exactly one row beneath the last used row in the store sheet. I have had mixed results but none that i can find does exactly what i need and looking for some...

I have a workbook with 3 worksheets: WS1 has 3 columns (A,B&C). Column A contains a set of numbers and column B contains text, both beginning in Row 2. (Column C needs the formula I'm having trouble writing.) WS2 contains 2 columns of text (A&B), both beginning in Row 2. WS3 contains 2...

Instead of looping through one worksheet "RVP Local GAAP" how do I change the below code to loop through two worksheets along with two ranges? Not only "CurrentTaxPerLocalGAAP" but also a range called CurrentTaxPerGroupGAAP in WS2 and then also pasting values into not only RVP Local GAAP but...

<tbody> I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to highlight both the cells of "Column C of WS1" and "Column D of WS2". Example: Column C of WS1 500,000.00 260,000.00 65,000.00 30,000.00...

Hi all, Not that great on Excel so looking for some help please. I have the below VBA that will transfer data from certain cells on Worksheet 1 to different cells on Worksheet 2. It is copying the formulas in these cells where I need it to copy just the values. Sub DataTransfer() Dim...

I am trying to come up with VBA that finds a workbook in directory based on a value in A14 that is part of book name. Let's say A14 = 123456, there is a workbook named 123456 abc.xlsx in directory ( I have named this book ws1) and then copy a few values from that book and paste it in the current...

Hello, I was wondering if I could get some help. I seem confused on how to create a VBA code for a specific function I am working on. I am a beginner, so I apologize. I have searched here and Google, but it seems to be confusing me more and more as I search. Anyways, here is what I am trying...

Hello there. I've written this code to find the last row in a sheet "ws2". Sub Registrering()Dim ws1 As Worksheet, ws2 As Worksheet Dim Fra As Long, Til As Long Dim i As Integer Dim StRw As Integer, EndRw As Integer Application.ScreenUpdating = False Set ws1 = Sheets("Rutine") Set ws2 =...

Hi, I have 2 worksheets, WS1 and WS2. In WS1 I have a table and in Column A is a reference number (unique). Currently 1 to 15. In WS2 I also have a table with multiple rows. In each row is a reference to a unique ref number in WS1. For example, Ref 1 may have multiple rows in WS2 that...

Hello Can anyone please tell what is wrong with my code. When I run this Sub CalcWriteMisc() everything works perfectly. Sub CalcWriteMisc() 'Calculates and writes misc. items to MiscItemsDB Dim ws2 As Worksheet: Set ws2 = ThisWorkbook.Sheets("DataEntryItemsDB") Dim ws3 As...