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...
Can I download/export details of vk13 (condition type- Slab Price with historical data) in Excel. Is there any T-code or table?
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.
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?
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?
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.
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...
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?
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....
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...
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...
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?
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.
I need to pass data from Excel to Host on demand 3270 mainframe and vice versa using VBA.
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?
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.
Can you install / run Microsoft Office Suite and LibreOffice Office Suite on the same Windows computer, 64-Bit system? Same Hard Drive?
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....
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?
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?