Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Share tech news, updates, or what's on your mind.

Sign up to Post

I have an Excel macro that takes various spreadsheets listing clients' offices (headers horizontal).  Uses the "Paste special, transpose" successfully to group each type of office  into its own worksheet - and prints that worksheet to pdf.

Works splendidly for what we need...if there are 6 locations or fewer.  More locations result in more columns, and "fat" worksheet is hard to work with.

So what would you recommend for me to create a "break", eg.  a worksheet with 9 columns from the transpose, I can print column-A( the headers) and 6 columns of locations, then below that print column-A(the headers again) and print the remaining 3 columns?

Bit stumped how to do it in Excel macros.

Example: original worksheet
(row 1)  City, Office, Address, Phone, Delivery Hours
(row2)  Smallville, Sam's,  12 Main, 444-1020
(row3) Smallville, Barn-it, 67 1st St, 444-4024
......
(row9)  Smallville, DQ, 53 Sweet, 444-5050
 
Example: transpose with a "page break", if possible!
City               (row 2)  (row 3) (row 4) (row 5) (row 6)
Office
Address
Phone
Delivery Hours

City               (row 7)  (row 8) (row 9)  
Office
Address
Phone
Delivery Hours
0
Free Tool: Site Down Detector
LVL 9
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I need to figure out how to do check templates with Microsoft excel 2017 spreadsheets  for work can u help me ?Or quicken books  premium or accountants can u help me? I need to edit it he just told me can anyone help me ?
0
Hi everyone,

I need help on a worksheet I am working on in Google Spreadsheets.

I attached the screenshot of the document I am working on.

2017-08-03_15h16_45.png
1, 2 and 3 have been imported from another Spreadsheet via the Import Range function.

In 4, I need to average 1, 2 and 3, but it's not working because the formula is not reading the value, but the import range formula.

Any help would be appreciated.

Thanks!
0
I have a database containing data for about 20 quality measures for a about 80 physicians.  I have a workbook built that lists the providers names, email addresses, clinic, etc.  I have pivoted the database to create spreadsheets for each provider for one measure.  (I will duplicate this for each measure).  What I can do is run a macro I've created to automatically email each physician their associated worksheet, based on the their email which I've placed on their individual worksheets.  This sends them a read only version of excel as an attachment to their email.  What I would like to do is have my macro embed a snapshot of the worksheet into the body of the email, instead of sending it as an attachment, but I'm not quite sure how to do that.  I'm not very excel savoy and am happy I have gotten this far.  Below is the macro I am currently using and I need to know how to edit this to get what I'm after.  I appreciate any help!  Thank you!


Sub Mail_Every_Worksheet()
    Dim sh As Worksheet
    Dim wb As Workbook
    Dim FileExtStr As String
    Dim FileFormatNum As Long
    Dim TempFilePath As String
    Dim TempFileName As String
    Dim OutApp As Object
    Dim OutMail As Object

    TempFilePath = Environ$("temp") & "\"

    If Val(Application.Version) < 12 Then
        'You use Excel 97-2003
        FileExtStr = ".xls": FileFormatNum = -4143
    Else
        'You use Excel 2007-2016
        FileExtStr = ".xlsm": FileFormatNum = 52
    End If

    …
0
Good morning Team,

I would like to thank you for your good work.

I need to know what does OrignalTable & OrignalKey mean.
UpdatedTable& Key mean when we are comparing two spread sheets.

I have attached Macro spreadsheet for reference. Once again. Thank you for your goodwork.

Const ksOriginal = "OriginalTable"
Const ksOriginalKey = "OriginalKey"

Also Const ksUpdated = "UpdatedTable"
Const ksUpdatedKey = "UpdatedKey"
Compare-Two-Worksheets-and-Paste-di.xlsm
0
hi I'm taking destination as a lookup reference I taken ID in reference table and nomatch ouput map to destination ,partial cache mode I'm using ,I'm getting duplicates to destination
0
I have already make a "XML Maps" Mapping list under the XML Sources.
It works file when I do the XML import to the Excel sheet.

However, I would like to add the file name of the XML which imported to the excel.
Can anyone help me on this?

Enclosed with the Excel sheet with the mapping list included
https://drive.google.com/open?id=0B-cvVcO00sRvVldicS1kWFhGSGs
0
I will be entering data, moving around a spreadsheet with the arrow keys.  Then the keyboard will go completely unresponsive.  I can change cells with the mouse, but still not enter any data.  This "spell" can only be broken by hitting one of the Enter keys, which pulls up a spreadsheet (none in particular) that had been minimized.  From there, i can go back to the previous spreadsheet and continue working as normal.  
I have not noticed any pattern to this.  There do not seem to be any favorite spreadsheets.
0
Just started a few weeks ago...while working in a spreadsheet, the program starts acting independently, moving from cell to cell...was I am typing formulas, half of the formula will be in the original call and the rest of it will be deposited in a random cell...it's like watching a video game...there is so much activity on the spreadsheet not being controlled by me...any suggestions?...I have run 2 full scans with Defender and they both came up clean...
0
This is in reference to a previous question:
https://www.experts-exchange.com/questions/29009094/Opening-Multiple-IQY-Files-for-full-page-queries-saving-one-cell.html?notificationFollowed=186018718

What I would like to have happen is if I could run a macro, and it would delete everything except the specific data in a cell whose location changes. This cell contains the text "( Displaying ### of ### )" and I would like to automatically delete every cell in the workbook except this cell. The location of this cell varies from workbook to workbook, so I cannot simply use a named-cell macro. I have hundreds of excel documents in this format, and in the end, I need one excel document that has the searched cell data from each sheet compiled into one workbook.

The Workbooks follow an identical format. I'd need a script as mentioned above, to delete everything but the necessary data and then save the sheet, then a second script that would take every Excel file in a folder and turn it into one excel file, with the title of the excel file being in Column A, and then the data from the searched cell (which would now be the only cell in these workbooks) in Column B.
0
Background

  • I have a workbook which has a simple table of all numeric data (except for the axis' labels of course) and a basic line chart based on that data.
  • This chart is embedded in the worksheet where its data is located.
  • I am using Excel 2013
  • Unfortunately I can't upload the actual sheet where I have the issue as it is confidential client data. I also can't recreate the issue.

Question

Normally when you click a line in the chart Excel will automatically select / highlight the source data for that series. In one chart however, although it shows the correct graph / values when you click on the series nothing is highlighted.

If I create a new graph of exactly the same type based on the exactly the same data (i.e. using the same series) then clicking in a series line highlights the data as expected.

Has anyone come across this before or have an idea what could cause this ?
0

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.