excel & macro

I'll try my best to explain what I am attempting to accomplish, we enter in serial numbers then a job number for shipping using a hand scanner. I scan the serial into a2 the cursor is set to move to the right to b2 to scan in the job number. I'm using a macro to move the cursor down to a3 after...

I am new to VBA and coding in general. I am trying to copy/transpose/paste a two-column PivotTable and I need it to paste vertically and break on blank rows. I need to copy each group in the PivotTable and transpose paste values vertically on a new worksheet. I cannot figure out how to...

Hello Team, I am unable to download and save file from website using VBA code. I have tried various methods for this still I am unable to download the file. If file is downloaded from another method its get corrupted. This problem exist only on this website this code works fine for another...

I'm trying to get workbook 1, all sheets used range, if cell value = a cell value in column a of sheets"Final" in Wb2. if so color cell indexcolor 6. the following cod runs but no color change. Sub color_matching_between_workbooks() Dim sh As Worksheet 'Dim wb1 As Workbook Dim wb2...

I have a data base that I need to be able to automatically archive and remove lines when there are a certain amount of out of date dates. My thought process is to run a check that will detect the out of date dates, select the entire line and remove the data to a holding page until the details...

Hi I have approx 500 companies which could have a balance with each other. So in total are approx 250K combinations. I am trying to group them to see whether the balances between them are correct or not. For example AB-CD should be grouped with CD-AB. I have tried to find MATCH and INDEX...

I have a master data file with telecom call information. The file contains 288K rows out of that I try to filter the information for 123 numbers to collate a cost overview. Data File - (MasterData) <colgroup><col...

I have a column (A) that has below values in different cells (A1, A2 and A3 and so on). PPC Revenue - 2015 Non-PPC Revenue - 2015 ROAS - <Enter PPC 1 Name> - 2015 ROAS - <Enter PPC 1 Name> - 2017 Non-PPC Revenue - 2016 Non-PPC Revenue - 2020 I need a macro that can be used to hide/ unhide...

Hi All, Hope everyone is well, I require help with the following, I have a sheet called data, which contains data exported from a piece of equipment. I would like to breakdown this sheet into multiple sheets. I require to create a copy of sheet '1', copy A15;E46 from 'Data', paste this into...

This is my first post.. I'm attempting to create a macro to do the following: 1.Input contains Mapping Sheet to Match different Headers Ex: <code>Mapping Sheet +------+------------+------+ |header 1 | header 2 | +------+------------+------+ |sam_name | sam.value | |John_name...

Hi. Not a pro coder but this is what I have so far. Sub SaveasPDF() Dim wsA As Worksheet Dim wbA As Workbook Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On Error GoTo errHandler Set wbA = ActiveWorkbook Set wsA =...

Hi. I have the macro below which upon running converts the active sheet in excel to pdf. Sub SaveasPDF() Dim wsA As Worksheet Dim wbA As Workbook Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On Error GoTo errHandler Set wbA...

=INDEX($C4:$K4,MATCH(P$2,$C4:$K4,0)) I use this formula to match single numbers in P2 with the defined range. Is it possible to change this formula so that it works when there are comma separated 2 or 3 numbers in P2. And if one (or more) of these numbers in P2 match with the defined range, it...

Hi, I been looking all over the place for a solution. I created two macros one to highlight the duplicates and other one to filter on the highlighted ones. I have the result set with all the duplicates and I need to take the max of Col L if that column doesn't contain zero, if it does look at...

Hi, I am trying to change the format of this table (un-pivot)- <tbody> A1 A1 A1 A2 A2 A2 YEAR Floorset Target Instore Newness Target Instore Newness FY20 100 89 25 200 193 55 </tbody> To look like this- <tbody> Business YEAR Floorset Target Instore Newness A1 FY20 100 89 25...

<tbody> A A B 3 C M D E GENBPAPP A 3 S GENBPAMIN A 1 SE SEBPA B 1 M GENLPA B 1 A GENLPA A 3 S CU CUAMIN </tbody> Hello, I have the above table (which I hope the format sticks around) as a lookup. I have rows of data that contain values. am looking for a formula or vb logic...

I can't seem to figure out how to jump to the next "c" in the loop after pasting my data. it works the first time but does not return to the first loop to change the c value to continue the process. any help would be great Sub CopyPasteData() Dim Pool As Worksheet Dim Family As Range Dim i As...

I do have Excel sheet in which I have inserted IF formula, i.e.=IF(C23='Data Nifty'!$AD$2,"CMP"," ") use of erlier derived "CMP" as above mentioned, is done in another condition i.e. =IF(A23="CMP",VLOOKUP($D$3,'Data Nifty'!$N:$Y,7,FALSE)," ") now the problem is, if CMP gets change with other...

I have 2 worksheets in a workbook, both have 2 columns as shown in Images below Sheet 1 : <tbody> FLOC COMP ABC-123 C1 ABC.124 C1 ABC.125 C2 ABC.126 C2 ABC.127 C3 ABC.128 C4 </tbody> Sheet 2 : <tbody> Comp MAT C1 A1 C1 A2 C1 A3 C2 A4 C2 A5 C3 A6 C4 A7 </tbody> I...

I currently use Excel spreadsheet to enter time sheets before I send them off to be processed. I currently use the current week time sheet (adding and deleting employees as needed) - and then after I enter the weekly time I save as the current week but use SAVE as new workbook and clear cells...