paper

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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