layout

Hello Friends, can anyone please tell me how to post my worksheet into the thread which will help me to post a layout of my data in a much better way. Regards,

I receive a number of data files each month from a number of different sources, and while they are all supposed to be in a standard layout (column headers and column order), they often aren't. I've written some code that checks to see if the values on the sheet match to either... - the...

Hi everyone! I have a spreadsheet with tabs for each month with the purpose of logging sales information. I created the entire spreadsheet as a group and every tab was set up in the "Page Layout" view and I had three separate pages ready to go on each tab. Somehow I must have clicked...

Dear all, I have created a very extensive document for invoicing, with many tabs. I have been using this document for a long time without any issues. However, I just opened the document and the information does no longer fit on the page (e.g. logo partly displayed on the next page). Does one...

Hi Excel Master, Every month, I'm require to generate a report. I export the data from a source, put in my excel file and have to arrange the column to meet my layout . My report has a fix layout whereby the column header is fixed (e.g A1 - Name, B1 - Address, etc). The source header text is...

Can anyone help with this please, I am trying to write some VBA to copy the following data in my spreadsheet to move to this format. Starting layout: Excel...

Hi, i built a macro to print from several files and sheets as pdfs, which is working fine. However, I wanted to specify the page/print setup orientation (portrait vs. landscape). I was hoping the below would work by specifying the preferred orientation in column G (e.g cell G5 will say...

I am using this from sample on web to get for Mar, last year Mar amount:- Last year:=CALCULATE( SUM('Transaction'[Quantity]), SAMEPERIODLASTYEAR(Calendar[Date]) ) It works only if the layout of my Pivot has Year and Month on Row Field. However, my report layout is always Year in page...

Hi everyone, I am having a margin/ruler/scale issue. I had a bad macro that broke and now I can't get the exact format back in my workbook. When I look at the sheet in page layout view, my ruler is at different points on the page between the good layout workbook and the bad layout workbook...

I am using Excel 2016 and want to add rows to repeat. I've tried the three approaches listed below. No matter which way I use, the Print Area and Print Titles are all greyed out and cannot be accessed, although I can change everything under Print Titles (Gridlines, Black & White, etc). Any...

Hello, Im working on a large file with around 22 tabs and I want to use VBA to consolidate all this data in a master file. I have the following code that I am using right now on my test file that is doing a perfect job of consolidating all the information: Sub CombineWorksheets() 'Declare...

Hi everyone, I need your expert advice for below I have a sheet of all the document number listed in Column A, Title in Column B, and Revision in Column C Document number will be same for all the revision coming Hence I want to track the exact current revision of the document Below is the...

Hi all, I am trying to do something in Excel and i think perhaps I am asking to much. I have data which is 3 columns qty and description and price, and they are broken up into "groups" ie rooms. I am trying to visually change this in excel to be 2 "columns" of this data which is currently done...

I am looking for the Control ID for table cells. I am trying to enable a right click for a SubMenu; I already have 'cell' and ID:=1588 for the Page Layout view, but can't seem to fine the ID for a cell in a table.

I want to find the last row in the last used page in page layout preview ( empty or not ) ... For example the last row in page 1 = 58 , Page 2 = 119 ... so on So if i have 2 Pages and my last data entered is in row lets say 100 ... i need the lastrow to be 119 not 100 ... any ideas using VBA?

Please i'm having problem of changing my Orientation (landscape or Portrait) on page layout is not changing hw do i solve it

Greetings, I am trying to export each picture on the activesheet to PowerPoint. They are placed on every other row and every other column i.e. B2, B4, B6, C2, C4, C6 Above those cells is the PPT layout type i.e. ppLayoutChart, ppLayoutBlank, etc. I want to export the picture and the related...

All our computers in the office currently run Excel 2016 on several different types of computers (Dells & HP's), however all operate with Windows 10. In the last few days each computer is experiencing problems with page layout view. It seems to be focused around conditional formatting using...

Hello all, I have two workbooks; #1 : "FUEL TRACKING WORKBOOK -> sheet QTY By Inv Customer" , #2 : "12.2017 Airport Fuel Billing -> XX-2017". (where XX = numeric month) Workbook #2 sheet layout has three columns that may or may not all be filled out, ACCOUNT...

I would like to use excel to print some tables to pdf and use them in pdflatex later. So I want to keep the size of each tables in excel. My questions is if there is a way to create a new pay layout automatically which is consist with the size of the selected printing area? thanks in advance.