excel & vba

I am fairly new in excel vba scenario. What I am trying to accomplish here in this macro is,I have two sheet, two column, sheet1 Column A, sheet2 Column A, both have possible matches in column A. I am trying to find all the matches between two sheets and copy matched entire rows from sheet1 to...

Hi Experts, I have a sheet which runs into over 30000 rows. I need to find contra entries within a company in column B for a each job in column C. Basically I need to find which transactions sum to 0 in column K (Balance in Base). so for example, in company code IN9073 in column B, there are...

Hi Everyone, I Want to Split the column(or From Cell to the down) with the available text in the cell. I want do it without merging other columns. I hope following image can explain my concern. is there any way to do it?

So the current error I get is an End With without With I've tried to add something that has "with" and then I get the error "For without Next" and if I add a Next, then I get the error "Next without For" What the heck am I doing wrong? I'm trying to do the following tasks: 1. Create a folder...

Hello, I have been trying putting together a code to get scroll table data from web to excel from an internal url which does not open in IE. The code I have, however, only takes table (column) headings, not the values from table itself. The table on web updates every once a while on would be...

I have published a workbook, containing multiple optionbuttons, on a web page. I have attached macros to the optionbuttons via the onAction property. When users open the workbook directly from the web page (as opposed to saving it first) the optionbuttons call the macros in the web version of...

Hello all, I recently discovered the benefits to converting Excel documents to XLSB (binary), mostly the cutting almost in half of file sizes. I would like to apply this to some of my older files, but don't want to sit around resaving these documents. That macro should be able to search...

So I created some code that will allow a user to enter multiple pages of data and then just click a print button to click the number of pages of data he has entered. However we are running into a problem where by if a user enters 200 lines of data, then deletes the last 25 lines, it is still...

Hello there experts, I have the following code that successfully returns the values of any cells in column A starting with a letter A to Z: =IF(AND(CODE(UPPER('PL & BS Leadsheets'!A5))>64,CODE(UPPER('PL & BS Leadsheets'!A5))<91),'PL & BS Leadsheets'!A5,0) The range in sheet 'PL & BS...

Hi There We have a Fingerprint reader for our staff Time & Attendance. Attached the standard report from the device - untouched https://www.excelforum.com/attachment.php?attachmentid=607220&stc=1&d=1548060569 Now in this report, it give a daily breakdown of the Employee Check IN, Breaks and...

Hi There I'm stuck...Please help..:eeek: I'm a request fulfilment manager, and I have an Excel sheet which is an extract from our Helpdesk system. It's 70.000+ rows. Here is my challenge: In colum A I have a unique number for the specific Request i.e. RFxxxxx and in colum B I have an URL that...

Hi , The below link helped me to workout a old problem i was facing of copying picture from website to excel. https://www.mrexcel.com/forum/excel-...namic+url+cell Need help again. The Code and modules which was given was very fast , it processed 500 entries in 20-25 seconds . i had another...

Hi Friends, Trying to extract table data from multiple urls at once with Excel VBA. Here are sample urls trying to extract from ColumnA <tbody> https://www.abbreviations.com/acronyms/NETWORKING/149 https://www.abbreviations.com/acronyms/NETWORKING/150...

Good day Excel friends! I am needing assistance with creating a macro to count the number of emails in 2 exchange inboxes (not my default email account) with the date the email was received. for example Exchange email box 1: 31 emails from 12/28/2018 45 emails from 12/29/2018 58 emails from...

Hi Everyone, I am new to this forum and specially subscribed to get my query resolved. I have a system from where I download the report which is not in good format. Also the data is dynamic it keeps on increasing and decreasing I always have to copy it to a new workbook and format. Since this...

Hello, I have been trying to set up an automated email system based on expiration dates of research supplies. I have set up a code in VBA that can send out an email to the appropriate employees based upon when the supplies have expired. I would now like to include specific cell data from excel...

Hi All, i have the below code which runs when a cells is populated (but only works when manually populated). i have cells that are either manually populated (which it words fine for) and some that are populated via a formula (which is does not work for). do i need to change the trigger to...

I have many Excel file with multiple columns in the same folder. I just want to delete some Column, Each excel file contain the same heading.

Hello all i am using this code to change the font color to red color if ( Textbox3.value < textbox22.value ) see the code below please ... Private Sub TextBox3_Change() If TextBox3.Value < TextBox22.Value Then TextBox3.ForeColor = RGB(0, 0, 0) Else TextBox3.ForeColor =...

Hi All, I have searched all over the net and cant find the answer. I have a spreadsheets with hundreds of thousands of rows and hundreds of columns, I need to pull out the data that's in a row and add all into 1 cell but where it finds data in a row i need it to take the title name to the word...