excel macro

Hello! I need some help please if possible, is anyone able to write a code for me? I've had a look around online but struggling to find anything that can do the trick for me. I would like a script on excel to run when i receive a certain email in my inbox which goes to a specific folder. The...

Hi Guys, Thank you so much for reading my post. I really need your help to create the following excel macro. I want to get some particular data from the website but unable to get it. What i do is 1) Go the website www.ebharatgas.com 2) Click on "Transparency Portal" which is available on...

Simply put I want a macro to auto run upon launching excel 2014, to create Auto Time stamps in cells , when data is WRITTEN or PASTED into adjacent Column cells. I want to do this in multiple "column pairs ". The columns are paired but rows function indepently. Ex: Column A and B is a Pair...

I am attempting to move all of my visible sheets to a new word document. I have set up the portion of the macro that makes the appropriate sheets visible using IF statements. That works fine. Below is a code which moves all of the sheets (including hidden sheets) into a new word document. I am...

I am writing a macro that checks the value of specific cells on a sheet titled 1-SUMMARY and unhides specific sheets if the value of the cell is greater than $0.00.

Hello I have a workbook with 20+ sheets. All of these sheets relate to the "Summary" sheet. I would like to create a macro that checks certain cells in the Summary sheet (ex. A1:A8), and if the value in that cell is greater than $0.00, the macro will choose the appropriate sheet that relates to...

Shown below is the code that I want looped. I want it to loop it to 5 different colors (RGB(197, 217, 241), RGB (0, 191, 288), etc) to make the coding look neater. Otherwise, I'd have to copy and paste the code 5 different times with different color codings. Note that there are two areas in bold...

Hi Guys, I have a quick question. I have almost 100 too 200 excel files which i want to import and the sheet name to sheet1, sheet2 and so on OR else just change the first sheet to sheet1 and save it into another folder called NewExcelSheets. Thanks

I am trying to create a macro to catch all information for different time frames. For example, if there are 105 items, the macro below would only catch 100 of the items to sort. The selection for the macro does not have a specific range but the sort function does, which wouldn't make the macro...

HI, I am sure it is simple but I know nothing of macro editing although I recorded this one and simply need it to repeat on each consecutive row to line 228 so its range is set at A18:J18 I then need it to run on A19:J19 then so on till A228:J228 I would greatly appreciate any education on how...

Guys i have cross-posted in other forums, please go through the links to find replies to my posts - http://www.excelforum.com/excel-prog...ml#post3617163 http://www.excelguru.ca/forums/showthread.php?2769-Validation-for-data-mismatch&p=11910#post11910 Hi All, I used to copy row data from...

Hi, I'm getting a runtime 1004 error: application or object defined error on the code below Seems to be in relation to "ActiveWorkbook.Connections("Database2").Refresh," Any advice appreciated. Sub Send2Access2() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim...

Hi all, Hope you all doin good..well am new to this forum as well as VBA.I have a 30+ seperate excel files in one folder.The sheets contains data for a single month for 30+ projets.I want to pull the data into new master file using excel macro.Im trying to create macro .What i need is 1.The...

I thought it was simple but couldn't find a solution so far : how can i write some lines in an excel macro to produce a sound signal on another pc in the windows home network ?

Hi Friends, Need your help to modify this macro. I have a macro in which we can mail through excel sheet having a specific text in last column and row. It's working perfect as i want but now i want to modify this according to my another need. In this macro it is searching for last row and...

Lotus code looks like this except it was all on one line: <BASEFONT color=#000000 size=1 face=Arial LOTUS_SIZE="10"></BASEFONT> <TBODY> {?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{DOWN}{LEFT 4}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{RIGHT}{?}{DOWN}{LEFT 5}{BRANCH \C} </TBODY> I let Excel...

Dear All, Request your help in VBA. I have a code (Really good code, thanks to Mr. Vog) in which we can split the data using column values into new and same sheet also. I want to modify this accordingly to my need but i am new in VBA so can't modify this. i want 2 changes in this macro: 1. I...

Dear Friends, I need your help to get this done. I have a macro code in which we can convert .TXT files to excel files. We have a software who generate .TXT files and we convert those files into excel sheets. The below mentioned code works find but not as per requirement. The .TXT file data...

Hello, I am trying to create a Macro so that when I push the command button it will add a new employee to the bottom of my current list. I am having problems creating a loop that will identify the last row that that data and input the new data in the last row; right now it keeps overwriting in...