• Download details of VK13 in Microsoft Excel

    Can I download/export details of vk13 (condition type- Slab Price with historical data) in Excel. Is there any T-code or table?

    Marmik5 pointsBadges:
  • VBA Do While Loop

    Dim iJob As Integer Dim strJob As String iJob = 5 Do While ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value <> "" And iJob <> 4 If ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value = strJob Then Select Case ThisWorkbook.Sheets("Defaults").Cells(iJob, 21).Value Case strJob...

    Wolfehound725 pointsBadges:
  • Deleting filtered Microsoft Excel rows

    I have a Microsoft Excel spreadsheet that has over 50,000 rows. After applying a filter, can I delete non-consecutive rows? The Visible function doesn't work because there's too much data. Thanks again.

    ITKE1,012,135 pointsBadges:
  • How to autofill Microsoft Excel column with series

    In Microsoft Excel, I can't autofill a specific column with a series. For example, this is out I want it set: Jan17 Feb17 Mar17 I'm doing a right click and drag but that's not working. Any idea on what I should do?

    ITKE1,012,135 pointsBadges:
  • Find max of visible Microsoft Excel rows

    Sorry if this question is confusing. I'm in Microsoft Excel 2010. I have several rows of data. I would like to find the max for each specific row. But here's the catch: My formula should only take the max from visible data (not hidden). How can I do that?

    ITKE1,012,135 pointsBadges:
  • How to convert a .SHS file to Excel?

    How can I convert a .SHS file into a Microsoft Excel file as with .SHS. My computer is not able to decode it? Please tell fast its an emergency, I have to work.

    daaku35 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • How to convert Numbers file to Microsoft Excel file

    Not sure if this is possible but I thought I would give it a shot. I have both a Windows and Mac PC. I have a spreadsheet on my Mac that's a Numbers file. Would I be able to convert to an Excel file for editing on my Windows PC?

    ITKE1,012,135 pointsBadges:
  • Autofill PDF form using Excel data

    I am a Visual Basic newbie and I need some help with the following code. Basically, what I am trying to do, is to autofill a PDF form using data in an excel worksheet. I did some testing and the program seems to be reading the required data from the excel cells but not writing it in the PDF form....

    shawnturner10 pointsBadges:
  • Set Microsoft Excel 2016 document as read-only and password protected

    I used to run Microsoft Excel 2010 and what was great about it was that I could set my documents as read-only and if one of my co-workers wanted to make any chances, they would need to put a password in. But now our company upgraded to Excel 2016 and I can't find that setting at all. Does anyone...

    ITKE1,012,135 pointsBadges:
  • Adding tax data in Microsoft Excel

    I am trying to move tax data from one Excel sheet to another, organized by zip code. In one sheet, which has the tax data I need, the data is organized by AGI. This means there are 6 data cells for each zip code. However, In the Excel sheet I am moving this data to, there is only one line for each...

    caseyp75 pointsBadges:
  • Text file format is taking up more space than Excel file format

    In my Microsoft Excel spreadsheet, my data is in roughly 10,000 rows. But when I stored the data as a text file, it's taking way too much space. Why is it different as a text file than an Excel file format?

    ITKE1,012,135 pointsBadges:
  • Microsoft Excel: Round two decimal places

    Sorry if this is a basic question. I'm a Microsoft Excel newbie. How can I add two more decimal places without rounding it off? Basically, if I have $50, I want it to show $50.08. Thank you.

    ITKE1,012,135 pointsBadges:
  • Needs to pass data from Excel to host on demand

    I need to pass data from Excel to Host on demand 3270 mainframe and vice versa using VBA.

    Kavithagowda5 pointsBadges:
  • Create random sample of Microsoft Excel data

    I'm looking to do some random sampling on my Microsoft Excel spreadsheet. Basically, it has over a thousands rows on it and I want to sample around 100 of them randomly. Would this be possible? If so, what's the process?

    ITKE1,012,135 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE1,012,135 pointsBadges:
  • Importing Excel to Access auto populating data

    I have imported an Excel spreadsheet into Access (2016) and am trying to figure out how to populate data. For example, I imported a spreadsheet containing employee name, ID, Department, Supervisor. If I select the employee name, I want my form to automatically populate with the rest of the data....

    motogirl15 pointsBadges:
  • Update changes to Microsoft Excel file in Dropbox

    Hello, At work, I have a Microsoft Excel that I'm always updating. Would I be able to upload / update it in my Dropbox account every few hours so I don't lose any data?

    ITKE1,012,135 pointsBadges:
  • Cannot delete Microsoft Excel macro

    I have Microsoft Excel 2013 installed on my MacBook Air. I'm trying to delete a macro but I keep getting an error message: Cannot edit macro on a hidden workbook. Unhide the workbook using the unhide command. My worksheet is already unhidden so I'm not sure what to do here. Can someone help?

    ITKE1,012,135 pointsBadges:
  • How to import Microsoft Excel data into existing SQL Server table

    We have a SQL Server table that currently has data in it. Can we import more Microsoft Excel data into this existing table? We already tried using the export wizard but we got a ton of errors.

    ITKE1,012,135 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following