mass

<tbody> Hi I am having an issue performing a mass update on url addresses within excel. I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person. The root file...

What is the best way to sort mass data through a pivot table. I'm fairly new to pivot tables and want to sort by ship-to's but there are so many that the pivot looks overwhelming. These are the columns I'm having to handle. <colgroup><col span="6"><col><col><col><col...

hi guys, I am new to VBA and I need help copying data from multiple worksheets to a single sheet in the same workbook. my workbook has 12 worksheets named by their moths. each worksheet has a number of rows that gets updated. please note that some fields of "Importer" are blank. for each...

Hi all, I have a pivot table that I would like to filter to only display records from the month of June. All of the records are time stamped, so I'm wondering if there is a way to mass select all values from 6/18? It doesn't seem to work to shift-click to mass select. Are there any other...

First of all let me state that my coding ability is very limited. I have a pallet scale display hooked to Excel via serial port. I currently have the excel doc set to display the scale value to Sheet1, C1. What I want to due is create a macro to calculate the mass rate of change (i.e. pounds...

Hi Excel Pro's I am hoping that someone could help me, please.... I recently started using Ron de Bruin's Mass Mail template which works great but now I have been tasked to do personalise e-mails to separate individuals which must include a table with certain results which will be unique to the...

Howdy, I have used this code before for other sheets in my workbook. I changed the name to be the new worksheet and adjusted the code throughout my workbook to include the new worksheet. I get the Compile Error: Variable Not Defined when ever I point to the Set wsIBMass (new worksheet). I am...

Hello, Formula: =IF(LOOKUP("$",G10,F10),F10*$K$3,IF(LOOKUP("€",G10,F10),F10*$K$4,IF(LOOKUP("₪",G10,F10),F10,""))) Issue :(: Only the first "IF" is working properly while the rest result in N/A# Formula goal: Currency check and exchange Further details: CELL G ($,€,₪) = CURRENCY TYPE...