package

Hi all, I have a column with text that I need to extract into another column. I'm using an IFS(Search) formula to do this which is working for some of the text in my first logical test but not the second even though the text is present. formula =IFS(SEARCH("GrainPro",M92),"GrainPro...

Hello, I'm having a problem trying to develop a code that will enable me to automatically insert a row as enter is pressed. Sounds easy, problem is this needs to happen throughout the excel sheet. There are titles to drawing packages in the sheet, two blank spaces between each title. As...

We have a booking package issued by our corporate office, and we have a local PM file we use to mange our construction projects within our office. Obviously, the data in the PM file is originally sourced from the Booking Package, however the data within the booking package is across multiple...

Hi all, This may be a bit of a long shot but I am trying to create or put together a VBA Macro for package distributions that will send out multiple email notification emails at once to the approriate point of contact each with slightly different subject header based on their location and the...

I'm having a math/excel problem. I have a sheet of values. In column A I have package quantities, column B a value that our system says to order. In column C I'd like to produce a value that is the nearest divisible number to what shows in column A. A B C PACKAGE...

Good day all, I have customers that need to be picked up every few days, sometimes a large package and sometimes a small package, the type of package is known at the beginning of the year. Is there a possibility to automatically divide this over the year? For instance: Client1: has at the...

Hello All, I have a project which requires a tool that is capable of looking at a set list of file names, a specified sub folder and seeing if the file exists, if so, then make a copy of the file to a specific Directory and update the workbook that I will trigger the code form with a "Saved...

Having trouble finding the solution to this if there is a simple one. My formula looks like this: =COUNTIFS(Model,$A10,Package,$B10,Status,"*DS*") But it is not returning anything. I'm assuming this is because B10 contains varying numbers with 0's in front like "01" or "02" but the Package...

Hi Everyone, First time poster here although I've been referencing many posts from this forum for years. So much great info here. I'm trying to submit package info to the UPS site to automatically return the shipping rates. For a single package I'm able to do it. When trying to set up for...

Hello, I need a macro, which would go inside every zip package, remember the name of language folder inside and add that name to the beginning of package's name. Example: I have many packages in location: c:\Desktop\packages\ The packages' actual names look like this...

Hi, ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...

As I have been writing my wari game, I need a function to return two arguments. I came up with this way. It may already be known, but I thought I would share it with anyone who needs it. The idea is to return an array into a variable THAT MUST BE DIMENSIONED AS VARAINT. The Function itself...

Hi all, I am fed up with my apartment complex's inability to notify myself and other residents whenever we receive a package to the building. So I am preemptively making a simple excel file for them to use to notify us when a package is received. After creating a tracking sheet for them I...

Hello eveyone, Im looking for asssitance on calculating a buket level and total buckets, based on a comparison to another sheet ( Red culms) In order to emphesize here is an example; Sheet A ( Spend) <colgroup><col span="4"><col><col span="2"><col><col...

I am new to excel and using macros, but I was wondering if someone could help me out. I have to let users select however many packages they want to see and then look at certain cells within a range(The range will be the same for each package) for certain data/formulas. If the data in the cell is...

I have a helper column where I have formulas that returns "DUP-####-XXXXX". DUP represents duplicate #### represent a part number xxxxx represents the package name that the part is in. My dilemma is lots of time the part number might be used twice in one package and only once in another...

Hello gyus, I am trying to develop smart excel chart, where user can attach file. For attaching files I am using button with this simple code: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit...

Hi, I developed some macro codes and it involves sheets associated with the code. How can I distribute this to others in the company? When I save its as a .xla addin format and use it. The addin doesn't bring in those sheets. How do I make it happen. Or is hosting the file in the server the only...

I have a program that calculates the shipping rate to customers. In order to do this, I need to give information to UPS to calculate a rate quote. Every one of our products has got a gross weight and "individual packaged dimensions" as if each product were already packed in its own box. I am...

Hi everyone, I need some serious help! ... so any help would be awesome ... :) I have an excell sheet that takes inputs (let's say A, B, C) for three cases (let's say 'baseline', 'low', 'high'). This sheet then does a bunch of calcs and produces ouputs (let's say X, Y, Z) for each of the...