0.0px

Hi Everyone! Happy New Year! I am trying to make my VBA faster - It is pretty slow for now (30 secs) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; color: #000000}</style>need a faster way to vlookup instead of having to manually scroll down all your data. on PC you can hit ctrl,shift,down and it will highlight all your columns to your last field with...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545; min-height: 14.0px}</style>I am reaching out to you guys because I have no experience with VBA but I...

hi i have 3 columns in a spreadsheet i want to extract the blanks from A (or B) that dont match the exact sku in B (or A) is there a quick find/sort way to do this? thanks in advance for your help!!! joe =) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #003ecc}</style>I have a worksheet of all of my students in A:H. In column D I have the class period for each student. I'd like to dynamically filter each class period to its own separate...

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545 } p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545 ; min-height: 14.0px} p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height...

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px} </style>Hi All Can somebody please tell me why these statements come out this way? K1 = 01/10/2018 (Dropdown list with...

I'm using Microsoft Office for Mac 2011 and I'm simply trying to find if a value from one list is in another list. In this case I want to see if MM33 (A2) from list A is in List B. I've tried using a column array, a range, and cell specific formulas. The column array and range does not find...

Hi All, I've found a macro online that I am using to save a fixed range to PDF, with the name generated by cells within the sheet. However when I try to run the macro it returns this: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px 'Helvetica Neue'}p.p2 {margin...

Hello I have a problem with the Vlookup feature, Kinda...I figured it out how to get the information in there but it is grabbing the wrong Info. I will start off by explaining the kind of information I have going on here. I work for a school bus company and we do alot of trips. I want to be...

hi i have a spreadsheet with several thousand rows. i know how to find dupes (through conditional formatting) - but i don't know how to filter to only show the dupes is there a way someone can share with me? thanks so much =) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font...

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}</style>i have hte below code but it doesnt work for some reason! the code runs without breaking but it does not format at all...

Hi, I'm trying to pull in the Employee Name based on a Manager's ID Number. For example, if I type in 1234 - I want the table below to fill out with all of her direct reports. But with Index Match, it only pulls in the first result. Is there a way to pull in the new next result and keep going...

hi my data loos like this <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}table.t1...

Hi Everyone, I'm currently using this formula to add and roundup two values: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Times}span.s1 {font: 12.0px Arial; color: #0433ff}span.s2 {font: 12.0px Arial}</style>=ROUNDUP(SUM(A1:B1),0) But now I'm stuck trying to add...

Hi I'm trying to import data regarding AWS pricing for London region from #000000[/URL] ]ec2instances.info website using VBA, but I always get data as if it was Northern Virginia region. I tried the following: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo...

I'm looking for some help. I have some sales data from a report that i plan on running every day. So everyday more data will be added to the bottom of the existing data. I want to have a column on another workbook that will make a new list from certain columns within the data whilst ignoring any...

Hi. I'm not a programmer and need help for a local company I'm working with. I have a spreadsheet that has a fixed number of columns (number of rows changes), BUT the dates on those columns can vary. I need to transpose the data and copy the company for as many dates it has listed. There's a...

Hey, I need help sorting out student attendance data. <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; -webkit-text-stroke: #000000}span.s1 {font-kerning: none}</style> For example, this is January Sheet. Data is sorted by Column B (#ID)...

Good morning, I'm working on file that will show me the total requirement for a specific part on a specific day. Unfortunately there are multiple line items per part on a day. I need to find a way to return the total value on a specific day. I started with the below formula, but it only...