vba - help

I have a sheet of raw data and column J has departments and Column C has SKUs due to a couple of the lines being split at the POS 50% in one dept and 50% in another I need to write VBA which when it comes across SKU 4321 in cell C6 will copy the contents of cell J5 into J6. I can do this fine...

Hi everyone. I just wanted to know if it's possible to determine if someone copied and pasted code from one VBA file into another VBA file. Im using Excel 2010. Thanking you in Advanced Zee

Hi, I've been reading numerous posts, watching multiple youtube videos, and wildly searching the internet for several days now trying to figure out how to create a VBA/macro to suit my needs, but am still stuck scratching my head, so hopefully someone here can help me! :confused: I have a...

Hi guys, wondering if anyone can help me please, I have a master excel data file and I would like to sort it and do some vlookups with a VBA and then save the data into separate excel workbooks that contains a pivot table and saves into a specific folder location. I have no VBA experience...

Hi All, I am using Excel 2007 and have a test question database that I need some help writing a macro for. In sheet 1, I have the master question list. Each row contains a question and its associated elements. Column A lists the version (A-C) of the test that the question is applicable to...

I am wanting to subtotal banking from a number of stores from security company receipt sheets. On the sheets column A contains a:- "L" where column C has the location name "B" where column N has the daily banking figure. I need to get the period banking subtotals for each location and then...

I need some help making modifications to vba that applies conditional formats to one of my reports. The existing macro creates a conditional format and copies the format over the entire report. The vba I use creates a conditional format on cell $A8 and bolds the cell if it starts with " ["...

Hi All, I have a problem which i am hoping someone can help me solve using VBA, I have a table that looks like this: <tbody> Group No. (Key) Material 9400028741 600-1014:TELSPEC 9400028741 597/29:TELSPEC 9400030162 BFD328507:ERICSSON 9400030162 BFD328507/11:ERICSSON 9400030162 BMS...

Dear All, I am new to the Excel macros and VBA tools and however i have some design idea how My Tool needs to implemented, We need your support and assistance to get this created, please help here. Need a help to create macro code by using VBA command Tool. I have 3 sheets here. A. Summary...

Hi everyone, i am pretty new here and need help on a VBA macro. I have a bunch of data (expenses) for different clients in one single sheet that I would like to split on different sheets. Basically what I would like to do is to create one sheet per client, each sheet named with the name of the...

Hi, I’m trying to create a VBA code to Save the current work book and then send to a specific e-mail address. I’ve managed to get it to attach the file to an e-mail but can’t seem to get the other bits to work at all. Below is what I am trying to achieve. if sheet 1 O5 or R5 or U5 = “Not...

Please help me, have search the entire internet for a useful VBAcode Is it possible to make a code in vba to plant a picture inside the emailbody of a G-mail? Or just transfer a table to the emailbody? I’m using CDO messaging to send emails from Excel via G-mail. Best regards Mia

I am an SAP developer with little knowledge of VBA. I am creating an VBA to post data to SAP using a BAPI. The coding is working fine & I am able to post data into SAP. My problem is I have several rows in my excel, I have to loop the rows one by one & upload data in SAP, after each upload i...

I am actually fairly new to VBA coding and is at the point where I am trying to learn how to debug a current program given to me by a coworker that I wish to understand and possibly improve to suit my needs. Public Sub Patient_Records() Dim FF As Long, strText As String, strFile As...

Hi, i have the code below that moves data from one work sheet to another. This code works as follows Iterate across each column header in <CODE>Sheets Summary</CODE> and see if a matching header exists in <CODE>Sheets Log </CODE> <CODE></CODE>If a match is found, copy the column contents...

Hi, I have a macro that need to: 1) find all occurences in spreadsheet-1 (every occurrence is a set of 3 cells, for example B1+C1+D1 2) move this data to spreadsheet-2 3) clear this occurrence in spreadsheet-1 This is the code I tried for these steps: Do sheet1.activate Set...

I just encounter this issue and want to find a solution to auto filter just the most recent date in Pivot Table via VBA. Like I want to set "TIME" column as filter field in Pivot Table. I searched online and modified a little bit to see whether it could work. Here are the codes: Module1: Sub...

I have a range of data from A2:A10 that i am displaying through data validation drop down list. I want to display a default value when i press delete on any of the cells in range .The default value -"Select Value" which will always be displayed when i am going to select a dropdown value.Please...

Hi Im new to this forum so hope this is the type of question. I have monthly workbooks which i use to verify data from a number of sources, most i have macros to import from supplier spreadsheets. My problem is one field has to be manually added by someone in another department. They need to...

I am stuck and don’t know where to even begin and am not even sure if what I want to do is even possible, but then again, I really don’t know VBA. I’ll be as specific as possible. I’m looking for a solution to the following problem, likely VBA code. I have a workbook with “Sheet 1” and “Sheet...