ws1

Worksheet 1 contains data I want to sort. WS2 contains relative cell references (=) to WS1. When I sort and filter WS1 the cell references in WS2 do not change so the data in WS2 is incorrect. How do I solve this please?

hello all I have this script which functions as expected, what I'd like accomplish prior to replacing the applicable values is highlight the values. unsure maybe stop at this point or continue to the replacement. Thanks as always Sub HighlightValues() Dim c As Range Dim k As Variant...

Hi again! <colgroup><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> My formula isn't working as intended anymore. Here is what I wanted: I have 3 worksheets: WS1 WS2 WS3 WS4 Vendor name Expiry date Formula field Vendor name Vendor...

Hi everyone, I got lost trying to do a formula... Hope you can help me! I have 3 worksheets: <colgroup><col><col><col><col><col><col><col></colgroup><tbody> <colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>...

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

Is there a way to define worksheets once and have different modules use that definition? So if I Set ws1= thisworkbook.worksheets("Sheet1") i can use ws1 in any code and it will know the reference?

Looking to interpret how exactly this works? I love using it, but i really don't know how it works and how i would manipulate it to work in other scenarios? Set ws3= ThisWorkbook.Worksheets("Sheet3") Set ws1 = ThisWorkbook.Worksheets("Sheet1") Dim lastrow, lastrow2, i As Long Dim Searchfor...

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

What am I doing wrong here? Sub Appenddata() Dim lastrow1 As Long, lastrow2 As Long Dim ws1 As Worksheet, ws2 As Worksheet Dim WB As Workbook Set WB = ThisWorkbook Set ws1 = WB.Sheets("ACT") Set ws2 = WB.Sheets("OFC") lastrow1 = ws1.Range("A" & Rows.Count).End(xlUp).Row lastrow2 =...

Hi, I have 3 sheets. Sheet 1 (RAG Open) has 140 locations in column B. I want the user to be able to click on any location in column B and for the vba to take that choice and paste it into A3 on sheet 2 (formulas), whilst taking the user to sheet 3(office view), which is now populated with a...

Hey guys, just need a little help rewriting this formula below, Sub Duplicate_Val() Dim lrow As Long, ws1 As Worksheet Set ws1 = Sheets("Datasource") lrow = ws1.Cells(Rows.Count, "A").End(xlUp).Row 'Adjustments Lastrow Application.Goto ws1.Range("L10") With ws1...

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

hi all, good morning, hoping you can help :), i have the code below where i am triung to copy cell C1 from Sheet1' (another workbook) and paste into 'ROTA' which is another workbook into cells B2 to B27, but its coming up with an errror, can you help me please :) rivate Sub...

Hi Guys, I'm trying to include error handling in the VBA below. So basically if the file (Workbooks("Pmet_Activity.csv")) doesn't exist, i'd like it to continue running ws(1). Thanks in advance! Sub BNPAll() Dim wbMO1 As Workbook, wbMO2 As Workbook Set wbMO1 =...

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

Hello all. I want to check if a column within a table has been completely populated with input from the user. If there is missing data input, the routine exits. I've tried to use the WorksheetFunction.CountA(rng) function, but I'm not getting any results. Do I need to insert a loop function...

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

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

I have a form with a combobox, that is tied to a range on a worksheet. The range can have multiple duplicate values. When a user selects a value from a drop down box, I'd like them to see only 1 of the possible values, and have the data presented tied to the max date of the Update Date...

Hi, I need a Macro in Excel with IF function. Basically the Macro goes through the first row of WS1. IF there is "Charlie" in A1:A3 (merged cells) the Macro will copy the range F2:H6 from WS2 and paste it below "Charlie" in WS1. IF there is "George" in A1:A3 (merged cells) the Macro will copy...