nextrow

I am trying to take data (both input and calculated) from one sheet and enter it to the next row on a table in another sheet and I keep getting the Error message "Run time error 1004' Here is the data on the "input" sheet I am trying to store on "Sheet4" Date 2/23/2023 mm/dd/yyyy Values...

Hi All, I am new on this forum. I have recently developed a macro through which I am able to list all files present in the sub-folders. However, there are large number of files (in thousands) and once I run my macro, it wants me to keep my hand on enter key for nearly 5 mins. Can any one tell...

I am trying to get my info from my text boxes in my user form into my worksheet. I have done this multiple time before and had easy success but now I'm getting problems. I either gut a runtime error or there is no data transferred. This below transfers no data to the worksheet Private Sub...

i have a userform to record my employee info, but i found something error sometimes when i enter a new employee. for instance, i save Leon Wong as the latest in row 6, but column C and so on will interrupt into another row like row 3. here is my code and where am i stuck with? thanks Dim...

<a href="http://tinypic.com?ref=ega2xg" target="_blank"><img src="http://i64.tinypic.com/ega2xg.png" border="0" alt="Image and video hosting by TinyPic"></a> Sub CopyToAnotherSheet2()'copy and transpose Dim NextRow As Long Dim cpRng As Range Application.CutCopyMode = False...

Hi, I have some code below. it works up to the line calculate cost where it just returns the value from the first if statement. Please help Sub data_sorting() Dim Bcell As Range Dim NextRow Dim I As Integer WS_Count = ActiveWorkbook.Worksheets.Count 'Jan...

Hello, I'm having a bit of trouble fixing an issue I'm having and not having much luck googling the problem. I have a loop that searches for certain things. What I'm trying to do is have the row that the search is positive for print the value from Column A of that row into another sheet. I...

Hi all, I’m looking for the lines of code that would allow me to merge cells in column A where the number of cells merged in that column represent the number of items written in the column B. Here is the code of the listbox 1 and listbox 2 that put items from those listboxes in the column B...

Hi Allz, I had help from theBardd to filter multiple Pivots having different sources with one click on a Slicer in this thread. But can any one please help to adjust the following code to link it with a cell instead of a slicer? Private Sub Worksheet_PivotTableUpdate(ByVal Target As...

hello all buddies, whats problem with my code below here, how come it returns column I-M with a wrong sequence? (column A-H is correct & prefect) <tbody> I J K L M N DATE CELL PHONE FAX REGION EMAIL expect 15-July-2005 1234 5678 NY abc@hotmail.com the outcome with below code NY...

I am new to macros and VBA, so may ask some stupid question. I want to create a macro that will automatically enter data to a webpage and copy the result and paste to anther web. Now, I am able to let macro to loop through the result which is a table, but can't locate to the data I want...

Please forgive me and any help would be greatly appreciated. I am trying to get a VBA to extract a shared calendar from outlook. The below will get my information but I am having trouble finding a way to get another calendar. I've been googling this for a while but most solutions are way over my...

I have a folder with 40 text files. The files contain test data from running the same test repeatedly on 8 test units, 5 times in a row. I expect to repeat this testing many times in the future, and so I am trying to speed up the data extraction time versus cutting and pasting. Once the data is...

I am getting a run time error '9' subscript out of range (in red) and I'm unsure why since it was working and now not working. I obviously changed something but I'm unsure what I did. Any help with this code would be appreciated. Thanks. Sub DistributeFromBiWeeklyPayroll() Dim R As Long...

Hello all. I created a payroll system in Excel and use a userform to enter employee data. See image below Named controls in order shown: Reg1 (DTPicker) TextBox1 (TextBox) Reg2 (ComboBox) Reg3 (TextBox) Reg4 (TextBox) Reg5 (TextBox) Reg6 (TextBox) When I click on the 'Add To Sheet' button...

Hi, I have the code below that outputs the email count per day for a generic team inbox, in this example the inbox is named genericqueries. I am looking for a way to also count the emails in sub folders within this inbox. Also, this email address contains roughly 8000 emails and it takes an...

Hi All, I am using the following code: Sub ReturnInvoice() Do Dim myWord$ myWord = InputBox("Insert the Voucher Number", "Voucher Search") If myWord = "" Then Exit Sub Application.ScreenUpdating = False Dim xRow&, NextRow&, LastRow& LastRow = Cells(Rows.Count, 1).End(xlUp).Row NextRow =...

Hello, So we have wrote a code that does so many things. But there is a last step we would like it to do. The step is that the data that is being pasted in nextRow=200 and down needs to be hidden. So basically after everything is pasted in the new sheets I would like cells 200 down to probably...

So I do I set a template to have information look better? I have wrote a code that creates and renames worksheets based on my list. Each worksheet has Net operating income statements. Now I need these sheet look clean and with a common template. So how do I add a template on top of the code I...

Please help! I'm trying to set a variable dependent on some input by the user. The user inputs 2 different times; and also selects the date. I need the code to compare these times based on "within an hour AND same day", "outside an hour" AND same day", and "Not same day". It's currently not...