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...

Some videos you may like

This Week's Hot Topics

Top