paper

  1. S

    Copy Data from 2 pivot table and make a new data set......

    Hi, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <colgroup><col span="2"><col><col><col></colgroup><tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer...
  2. kelly mort

    Trying to use "PageSetup.PaperSize" with a constant not working

    So I read stuffs and learned that I can use a message box to find the constant assigned to the current paper size then used that and pass it to the "<code style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit...
  3. Z

    Formula needed for ongoing spreadsheet with a look up

    Hi I have always used Vlookup but now I need a little bit more. I have a spreadsheet where 90% of the data and columns will remain the same but the on hand qty will always change. I created a small sample sheet where I have column A two different stores that care the same product number and on...
  4. S

    Is it possible to create a VBA code that would recognize phrases out of context ?

    So far I know how to extract certain words and potentially even match it into phrases without using VBA, but it is very crippled. But is it possible to teach/have VBA recognize the phrases out of text. Example: we need to recognize when paper was not in stock I went to store and did not...
  5. R

    Big upcoming overnight Automation project - How to ensure VBA completes its task when likelihood of crashing is high?

    We have an upcoming project I will be head of at work, where the manual click / wait / click / wait task that takes about 16 hours will be ran overnight. This task uses portals which interfaces with a kind of CSV database of information (advert file), but the portal opens up an Automation Hub...
  6. R

    Financial Planning Worksheet

    Hi, I am currently creating a financial worksheet to use for my clients. I already set the size to A4 so everytime I print it, it will be exactly in an A4 size paper. Now, here is my question can I expand the cells where I am currently working? and then when I have it printed it will still fit...
  7. D

    Formula help to create Inventory

    I'm working on an inventory sheet that pulls from received items on Sheet #2 . I have a couple of cells that contain variable (items) and I want to know if there's a way to have them added or subtracted from sheet 2 totals. Explained: sheet1, B7 contains either "shipped" or "returned". G13...
  8. E

    Carrying over into adjacent cell

    D1=5 D2=4 D3=9 D4=Sum(d1:d3) But I want d4 instead of showing "18", I want D4 to show "8" and C4 to show the "1"... But I want this formula for numbers as large as 1,000,000.00 So I have 9 individual cells from A:I across. And when ever the number is large enough I want it to "carry over" the...
  9. J.Ty.

    Multi-Dimensional Spreadsheet Challenge

    Dear All, My colleague Paul Mireault has created a Multi-Dimensional Spreadsheet Challenge. It offers an interesting and demanding Excel implementation problem. The solutions he gets are intended to be used in preparing a research paper for the 2019 EuSpRIG (European Spreadsheet Risk Interest...
  10. R

    Stop returning results after the first match.

    Hoping this is possible. In B I have a list of papers In X there is an IF(AND formula which tells me whether a product type (EU) is suitable for the paper or not. Where there are multiple papers, I'm seeing multiple EU's - I only want one, however. <tbody> B V W X Preferred X Result...
  11. R

    Here's a doozy - lookup against a list, determine number of same names, then apply a different formula to each instance.

    I feel like I'm abusing this forum with the amount of questions I have. On Column A there is a list 300-strong of paper names. You can have things like: <tbody> A B C 1 Paper Template Size Ideal Result 2 Banbury Guardian - Mon 16x9 Promo 3 Banbury Guardian - Tue 17x9 UK 4 Banbury...
  12. R

    Can anyone help me understand, then bodge this existing Macro.

    Hi guys, We have a sheet at work which is a very rudimentary tool to select adverts to run in local newspapers. What it does is display a list of 74 papers and then you select the row, click a macro button which opens an adselect window that displays a list of our products we can sell. We then...
  13. J

    VLOOKUP question - multiple cell criteria?

    Hi all, I was hoping you guys could assist. I am trying to make a spreadsheet for my wife who is starting her own business. I was hoping to use Data Validation (List) for her to choose what she is looking for: <tbody> Vendor Moo Paper Size 5 x 7 Finish Matte or Gloss Weight 16 pt...
  14. A

    Scaling to print out

    I have a spreadsheet that no matter what size I scale it to in page setup, it prints out the same size on paper. There are multiple pages. Can anyone help me please?
  15. P

    VBA Export as A4 PDF produces a PDF where paper size is larger than A4

    I use first the "ActiveSheet.PageSetup", to set the paper size to A4 and then the "ExportAsFixedFormat Type:=xlTypePDF" to create the pdf. When my work sheet is formatted to be with somewhat narrower data and the paper orientation is Portrait, the PDF is correct size 210x297mm. But if I format...
  16. A

    Clone worksheets, date/time functions (and God knows what else)

    Hello from Greece. A new, small project has started. A good and loyal colleague needs help with data entry of measurements. Let's start from the begining. Introduction Since the first of the year, the colleagues from a neighboring department take measurements from a number of pieces of...
  17. C

    Totaling Paper Bills and Coins?

    If I have a column of numbers (money amounts) is it possible that I could get a sum of all the paper bills and all the coins? For example: 12.75 22.50 56.10 Can I have two separate cells with one showing me the paper bills I have collected along with the actual amount of coins? Bills 90.00...
  18. A

    Trouble with VLOOKUP Matching text string anywhere in field

    I am trying to use VLOOKUP to match the text in Field C with the text in Field A and then populate Field D with the values from Field B. The formula I am using is =VLOOKUP("*"&C2&"*",$A$2:$B$7,2,FALSE). The first table below is the results I would like. The second table shows the results that I...
  19. O

    lookup

    <tbody> sl List box table chair paper 1 box devit 2 paper roki 3 chair sumon 4 table devit </tbody> plz help if i right devit, box column, the box automatic coming to list column, if i write roki paper will go to list column, below sumon, devit also same...
  20. B

    I need to help to draw graph

    Respected sir https://www.dropbox.com/s/4wbozu665e52pgu/25.jpg?dl=0 https://www.dropbox.com/s/7st3gzx0ihv2lw4/Book1.xlsx?dl=0 please find the links above i have attached graph,excel image drawn with pencil in paper i want to draw it in excel by using the Graph(Chart) slopes are taking 0.5:1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top