storage

  1. P

    Dynamic Find and Replace

    This is my first post, so apologies if I miss anything out! I have a selection of data in a Worksheet and I am currently using a find and replace array to correct some data before it get put into a Pivot Table. The problem I am stumped with is that the source cell (Column D) can contain a...
  2. L

    Saving an Excel workbook to multiple cloud storage (Onedrive,Google Drive,Dropbox)

    Currently I have a workbook on my C drive called Legends in a folder called Multimusic which I currently have to do three Save (Save As)actions in order to put it in a folder with the same name in my Onedrive, Google Drive and Dropbox storage. Ideally I would like to automate the workbook...
  3. D

    Referencing cell in another workbook

    First, I want to thank all the awesome people who have helped me so far. I've managed to streamline my tasks significantly with the VBA help that the people on this forum have provided. Thank you so much! Now, my current bit of tinkering. I use a single file that has my macros programmed into...
  4. S

    cell formula to get storage rate

    Hello, I am having trouble putting this formula together, and any help would be much appreciated. Storage: 7 free calendar days including devan date > $3.50 per cbm, or $50 min charge for next 5 days, 12th day - additional $3.50 per cbm per day - no min Cell H4 is a completed date H5 is the...
  5. M

    fiter blank cell and copy paste from another cell

    I need solution for below condition in VBA eg. 1) filter to Column AI for "Blank" 2) filter to column G for "Storage" 3) and print that storage in selected blank cell of column AI
  6. L

    xls application for iOS that allows local storage or dropbox storage?

    Hi Excellers! Best wishes for 2019!! Is it possible to save Excel spreadsheets to local storage or to attached storage (lightning to usb adapter)? Any solution? It seems Excel for iOS forces one to a) login (to a MS account presumably...) b) store files to the MS cloud I've had numerous...
  7. B

    Compare Two Pairs of Cells and Mark Rows with Matches

    Hey Guys - I have two worksheets which each have about 6 columns. Examples below... Worksheet #1 Example (Original) A B C D E F G PCModel1 PCManufacturer1 Value Storage CPU Link1 Link2 PCModel2 PCManufacturer1...
  8. R

    Warehousing and Storage Cost Calculation Question

    I’m trying to figure out a formula that does this: I want 12 columns for each month. In these columns will be calculations that adds the cost of storage based on the number of days that particular item is being stored. The first 15 days of storage is free, then .50 afterwards. How can I have...
  9. T

    Index & Match to ignore blanks

    Hi team, hoping you can help with the index,match formula to find the occurrence where the storage unit is not blank (or zero). The formula is referring to a table (called "Runners") in another sheet. The table is refreshed every hour throughout the day to bring in new data. Unfortunately there...
  10. S

    Stock Storage Find The Right Location For Each Item

    Hi am trying to put set or rules for my stock in storage i have got different sizes storage room and different sizes items i have made a set of rules of my items example any item less then 10-8-8cm = 640 cm cube (Group 1 ) 20-10-10cem = 2000 cm cube (Group 2 ) and the storage name and size...
  11. K

    Allocation Order Formulas

    Hello, I work for a real estate company that does not want to invest in property management software. Every property has a report that is set up in Excel to keep track of rent payments, etc. If the tenant pays for storage or parking in addition to rent, then the payments must first be...
  12. S

    If(AND Multiple Logic issues - Backup Tape Spreadsheet

    Hello People, This is my first post on MrExcel.com - apologies for not posting an introduction and diving straight into the issue I'm having with my Excel Formula. Basically, I have a tape storage record which I record all backup tape information. I have added an additional column called...
  13. R

    Drop Down Menu Value Storage

    Hello all, I was wondering if someone could help with this very strange problem. I have a drop down menu that conditionally populates the other cells with information based on what is chosen from the drop down menu. E.G: you click "January 2012" and it brings up values associated with January's...
  14. H

    Data in multiple cells within a merged cell is possible!

    Hi, Actually, I don't have a question, so I'm not exactly sure where to post this. I have no formal experience with excel, everything I know is self-taught. Love your site! I have often seen it mentioned that data cannot be stored in separate parts of a merged cell. This is not true. It...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top