ws1

My app is opening an Excel file, copying one worksheet to my new workbook and closing it. The problem is that someone in their infinite wisdom linked a file that was on their desktop and left the company. When the file opens it asks the question about Updating. Can I bypass this question all...

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

Dim lastRow As Integer Dim ws1 As Worksheet Set ws1 = Sheets("PayoutsTest") lastRow = ws1.Cells(Rows.count, 1).End(xlUp).Row 'Sum Columns With ws1.Range("B2") .FormulaR1C1 = "=SUM(R[1]C:R&lastRow&C)" End With Above is the relevant part of my code. The lastRow could be changing so I...

I need some help, please I have 2 worksheets with headers....ws2 is the master with 20 names as header and below (ROW 2) a formula {=SUMPRODUCT((Sheet1!$A$1:$XQ$1=A$1)*(Sheet1!$Z$2:$Z$39=Sheet1!$A$2:$A$39))} and ws1 has 9 names as header, (the names of the headers are the same), and below (ROW...

In my VBA code I create arrays from 2 worksheets: ws1 & ws2 I create 2 arrays, one from ws1 & another from ws2 and then loop through both of them (loop2 is nested within loop1) I need a decent standard variable names because I will do this procedure many many times. lws1 & lws2 ? Loop ws1...

I've searched for far too long and can't find the answer so I must post as this has got to be easy for the experts: 2 worksheets, WS1 and WS2. I want to clear contents on the WS2, then ***Link*** WS2 cell C1 to WS1 A3. That is, I want WS2 cell 1 to show "=WS1!$A$3" when viewed from excel and...

Hi, I am new to VBA and struggling to copy data to New workbook. I have wrongly referred the workbook. I want to copy data from ws1 to new workbook. but it is coping to ws2.I have to run macros from ws2 book. as I have placed more macros in ws2. macro is not running when I add new workbook...