excel & macro

I need to know what the VLOOKUP FORMULA is for moving numbers between these 2 sheets because I can not figure out the formula myself. I have tried all day, and I can not get it. JUST LIKE IT SHOWS IN THE SCREENSHOT ABOVE. I have 2 sheets named "Testing Day 1" and "Month 1 Week 1". I want to...

Hi All, I'm trying to send email from excel sheet, but before sending im getting a Outlook warning "A program is trying to access outlook email information..." with Allow, Deny and cancel button. im thinking of fully automating it but then this warning keeps on poping up whenever i sent an...

Hello everyone, I need some help with the macro below. I have everything working properly except the last part which is supposed to combine the saved excel attachments. Instead of combining theses attachments, Excel just opens a blank workbook. It seems like the macro isn't seeing any of the...

I am trying to extract certain columns from a downloaded spreadsheet that contains too much information. I only want certain columns and another column has concatenated data. How to clear all contents to last used row, but but leave formatting and formulas intact? How Paste Special all the...

Dears, I am having a data set with multiple named ranges with each range having one row and 14 columns. Column 'D' of each named range is always filled, where the copy will be required, ranges with blank 'D' column can be ignored. What I want to do is to loop through each named range and...

Hello Everyone, I have created a macro that gathers all the timings from a specific subfolder on a specific date from a shared mailbox and personal sent folder. When checking the timings from the personal sent folder there is no issues, but when checking from the subfolders from the shared...

Hi All, I'm new here so apologies in advance if I overstep on the etiquette or for showing my ignorance. I am really hoping you can help - my specific problem is as follows: I have text data in merged cells on columns B to D for each row from 200 through to 213 (so 14 rows total). I would...

Hello, What is the best way to convert following format into e.164 in excel i.e. i would like to convert numbers in the format 123 456-0001 to \+11234560001. Column A Column B 123 456-0001 \+11234560001 123 456-0005 \+11234560005 123 456-1000 \+11234561000

Hello, Looking for a VBA script that would extract numbers in a range to a separate column. Attaching a screen-shot of various possibilities of ranges. Below is an explanation of diff set of groupings that would like expanded into individual numbers. \+1234567891[01234567] - Anything in...

I have 28 tabs of data (named AB, BC, CD, EF, FG, GH, HI, IJ, JK, KL, LM, MN, NO, OP, PQ, QR, RS, ST, TU, UV, VW, WX, XY, YZ, Z00, Z01, Z02, Z03) in my spread-sheet with varying data (columns and rows are inconsistent) in each tab. I need a summary tab with count of each column per tab(only...

Hello, I wanted to automate calculations of the sumproduct of two arrays of variables which could iterate for dozens/hundreds of times, and then copy the results to a column, and then repeat the process, and copy the new results to a column next to the previous one. Upon completion of all the...

I created a macro button to copy a cell and paste value in another sheet but it just replaces the value in the same cell on the other sheet. I need it to count the columns and continue to paste the value in the next cell to the right. The code below is what i currently using to make it happen...

Hi, I'm making a break list at my new job for my team. Because the list has multiple entries we are forced to concentrate unnecessarily to calculate how many agents are on break. It would be helpful for my colleagues to see how many agents are on break right now, since we have a rule of no...

Hi If my selection range is a1: e5 then with below, we can have the first cell as fCell is a1, and last cell as lCell is e5. But what if, i want to get the first column last cell as fColLastCell is a5, and last column first cell as lColFirstCell is e1? Range can be vary time to time. Its not...

Hello, I'm facing problem when try to copy data from excel. As it is a large data in column "A" I need to use the clipboard option in transaction FBL3N. Unfortunately it does not work. I know that Copy Past in SAP does not work. However I do not know how to insert values (existing in Excel) to...

Dear Friends, i am learning VBA and went to several websites and forums and with the help of those i have created a small tool in excel. where it gets collated multiple sheets into one, as of i have mapped the drive and its working file however now i want any one can do this exercise and its...

Hi, I am hoping someone is able to help me. I have a workbook with about 300 tabs. All exactly the same format. I am trying to write a macro that copies all of the data from several cells in each workbook into a single workbook. Let me give more an example. A1 - First Name B1 - Last Name C1 -...

I am using a hand scanner to scan the word "OK" or "NOT OK" into the D column of a table. There are 2 more columns in this table to be used only if the D column is not ok. If I scan "OK" I want the cursor to move to the next row column A. So, if everything is "OK" I want the cursor to start...

In a sheet some 6000 rows are there. Id's are repetitive with different dates. I just want that macro will check the no. of repetition of each id and if the repetition is more than 12 times then it should delete the oldest date. (It means 12 times repetition is fine. If an id is repeated 13...

I have code to open 1 of multiple folders, depending on the selection. Previously it worked like a charm. Now it hangs on MyFolder. I have no idea what is wrong. I have trouble shot it, & it hangs on the same location. Here is the code: Sub Partner_Resources()Dim MyValue Dim i As String...