locations

Hi all I want to move files from Dropbox to One Drive so I can use auto save. Does anyone have any ideas on the best way to move Excel files and move the lookups from other files to the new locations. Cheers

I have a dashboard tracking the number of pallets stock that we have stored at a warehouse. Each pallet has an individual location, but each location may appear multiple times if it's shared with other products, so I have been using the following formula to count the number of individual...

I might be asking to much for excel to do this but is it possible for example i import a picture of a map and i was it to mark on the map locations with dots. so in the cell i'm typing the street name erie st. it marks with a dot or what ever on the map. i'm assuming i will have to program it...

If a company owns 15 locations across the country. They want to add new systems in each locations. Some locations require more than 1 system. Some of these locations are located in the South, NE, W and Midwest. the systems installed are as below: South - 10 systems NE- 1 systems West - 5...

I’ve got an excel file containing freight detail and I’d like to construct the following formula: <colgroup><col width="64" span="10" style="width: 48pt;"></colgroup><tbody> IF order # is between 100-199 and receiving location is one of the ten locations then - freight in IF...

Hey all, I have the following problem which I hope someone may be able to support with?! I have a list of locations in A-Z assigned to an Area Example from Cell E1 and F1 downwards... <tbody> 1 Aberdeen 2 Ashford 1 Aberdeen II </tbody> What I'm looking to do is in cell B1 have a box...

Hi, Unsure of the best way to approach this, it has to be with excel in some way. Basically wanting to synchronise data input between 2 locations. I was thinking maybe a MASTER workbook which stores data from WorkbookA and WorkbookB A VBA module to store data in the MASTER then a refresh...

OK, here is the issue. I have 37 different locations at my company that all have Safety Data Sheets. Some of the sheets will be common for more than one location i.e. WD-40, Windex...etc. I want to make a spreadsheet where I can reference one SDS to multiple locations so any location can...

trying to use the smart complete to create a range of warehouse locations. here is a sample below. with a max of the last decimal of 3. Thanks! <tbody> 011.001.001 011.001.002 011.001.003 011.002.001 011.002.002 011.002.003 011.003.001 </tbody>

I have several locations in my spreadsheet that have merged cell location that has the colorindex of 16. I want to save the address of the different locations in my sheet that have colorindex of 16 to several variables or an array.. How can i do this? thanks

Hi everyone, I regularly have to make a PowerPoint presentation for my study. Then I have a few dozen PPT pages, where I place texts and accompanying photos. My question: Is there a way how I can import urls or computer location (C: / Desktop .. etc) with photos and texts? The photos in the...

I have a data set of GPS locations for a wildlife research project. GPS locations were collected 2x per hour (every 30 mins). However, the GPS collars sometimes would miss a location resulting in 1 location/hour. I need to subset my data set to only include locations where I have 2 GPS locations...

Before I go into any detail I want to post a high-level summary of what I am attempting to achieve to see if it can be achieved. OVERALL On the worksheet labeled "TABLE", I have a table of part numbers(column A) that relate with each of my locations (account numbers) Columns B through P. Each...

I have a nephew that plays different country music gigs. He wasn't aware that he could claim the mileage on his truck to the IRS. There's no chance that I can get him to remember to write down his starting and ending mileage for each gig, but he posts all of his locations. What I need is a...

I can't currently figure out how to do what I want.. Here is the issue. I have a data set with quite a few lines. There are essentially two aspects to the data. One is the location, the second is the item. Each location has a row for however many items it carries. So if location 1 carries...

I think I am overlooking something incredibly simple. Whether this is just reformatting the data in a specific pivot table or adding in a logic step with a formula on the rows, but I can't currently figure out how to do it. Here is the issue. I have a data set with quite a few lines. There are...

All, I've tried to find someone post a similar question or find a similar use case to find the answer, but I'm not sure I have the right verbage to find my answer. I'm looking for some help with the data below. I have multiple locations going down which I've labeled "red" and "blue" in this...

Hello, Im lost with this. even my IT Department is having trouble. I have a list of parts. List 1 has single part number, description and total qty. well list 2 comes from another department and may have 1 part number with multiple delivery locations. My department would like to be able to use...

Hi Everyone I am having a difficult time trying to figure out how to accomplish the following task. I have a parts inventory, or parts storage workbook that tracks where parts are kept, or where they are located at. It utilizes part Numbers and a BiN# locations to Identify where the parts are...

Hi everyone, I'm creating a pricing workbook that will have worksheets added and removed based upon the number of locations I'm pricing out. For example, if I have 2 locations, I'll have my initial sheet, and then a VBA button will create another pricing sheet for the 2nd location. If I have 10...