Microsoft ApplicationsSponsored by jamf

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

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

Sign up to Post

Nothing to do with sheet1
delete the last cell data of each row of Sheet2
delete the last cell data of each row of Sheet3
delete the last cell data of each row of Sheet4

see the Result , I want the result in same sheet not in separate sheet



I have to do all this by Vba
Kindly see the sample file
Book1.xlsm
0
Free Tool: ZipGrep
LVL 12
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

SSRS Report Builder - Export to CSV issue; Double Quotes exist for each record.

We have a report that is scheduled to produce a CSV file.
This file is consumed by another application and requires specific formatting in order to successfully process the file.
The following entry has been configured within the 'rsreportserver.config' file:

<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                        <OverrideNames>
                              <Name Language="en-AU"> CSV No Header</Name>
                        </OverrideNames>
                        <Configuration>
                              <DeviceInfo>
                                    <NoHeader>true</NoHeader>
                                    <Extension>CSV</Extension>
                                    <Encoding>UTF-8</Encoding>
                                    <Qualifier></Qualifier>
                              </DeviceInfo>
                        </Configuration>
                  </Extension>

The file that is being generated from this contains double quotes at the start and end of each record (see below).
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
"DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY"
"180603,06/06/2018,AB,123,A,AB,123456789,-1234.56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TEAMJNL,123"

The output we need is shown below:
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY
0
Hi

I am designing an online SQL database for ordering products on my ASP.net web app.
I am trying to work out the best way to handle the "Basket".
The easiest way in my mind would be to retain the IDs of the items that
a user selects using cookies so that if the user leaves the page and comes
back I can use the cookies to show which items were selected.

An alternative option would be to have a SQL table that is structured
like my Products table. I would insert the user's selected items into this table.

I could also use my Orders table and show the Order status as being in the basket.


I'm looking for a little feedback on this. Thanks
0
In Excel 2010 I need to be able to list down all the unique values in a Column (Sheet1, Column A) and list those in Sheet 1 Column B (each value in a separate cell & ideally sorted Alphabetically) - The list might be any length.  I know this can be done in a pivot table, but for various reasons I am keen not to use one - does anyone know a formula that can do this?
0
What steps are necessary to determine if a Windows 8.1 OS that was upgraded to Windows 10 (with the data and apps being preserved) can be downgraded back to Windows 8.1?
0
I just upgraded a Windows 8.1 Pro computer to Windows 10 Pro by performing an upgrade that kept the files and applications in tact.

Now around 33% of the time when users logon onto the computer using their local Windows profiles they receive an error that says "C:\Windows\system32\config\systeprofile\Desktop is unavailable. If the location is on this PC, make sure the device or drive is connected or the disc is inserted, and then try again. If the location is on a network, make sure you're connected to the network or Internet, and then try again. If the location still can't be found, it might have been moved or deleted" (see the screenshot).

This computer isn't joined to any domains.

If we log off of the computer and then log on again (with the same or a different local user account) the logon is successful.

I have run the SFC /scannow and the following DISM commands which have all run successfully and reported no errors.

What can I do to fix this issue so that this error will stop occurring?

DISM commands I have run:

DISM.exe /Online /Cleanup-Image /Checkhealth
DISM.exe /Online /Cleanup-Image /Scanhealth
DISM.exe /Online /Cleanup-Image /Restorehealth

Open in new window


Desktop profile not available
0
Hello all,

So I've been tasked with exporting all partner's contact lists to CSV so we can compile them all together for a master list. We're using O365 and I was hoping I don't have to go to each partner machine (over 20) to run the export contacts wizard in Outlook. Is there a script that can perform this task or can it be done from Admin Center? Thanks in advance.
0
Greetings experts. I am trying to determine the AR based on invoices that are not completely paid. I have been toiling around on the web trying to figure this out; I thought it would be much more simple than it is. So, I was wondering how to get this excel formula I found on ExcelJet to work properly. The current formula reads:

=IF(COUNTIF($A$2:A3,A3)=1,SUMIF($A:$A,A3,$I:$I),"")

My Columns are like so:

Invoice#      Sales Order      Repcode      Account#      Invoice Date      Invoice Amount      Date Paid      Payment      Customer PO      AR Terms      Due Date      Amount Due

In the case of an invoice that a customer did more than one payment, I would like the total at the end to display nothing. Instead, the first line shows their balance due, then the second or further line shows blank if their balance on the invoice is 0.00. How do I get this formula to look at Invoice (column A) Invoice Amount (column F) and Payment (column H) so that if all balances are clear, do not show anything in the Amount Due (column L)? Any help would be super appreciated and thank you!
0
Hi everyone! :) Please help me edit this code so that the answer shown in the message box will be in decimal places.

Sub FunctionDivision()

MsgBox Division(5, 3)

End Sub
Function Division(x As Integer, y As Integer) As Integer
    Division = x / y
End Function

Open in new window


Any help is much appreciated :)
0
Dear Experts

I need some help with an excel formula (example spread sheet attached which will hopefully make sense) - basically I am trying to produce 2 formulas to work out when someone joined their current company (Company 1) & also when they got their 1st job - listed down in column A is their employer and column B the dates they worked in that job & column C their job title (which is always formatted with the company name first then a hyphen & their job title.  Their current company is always the 1st company listed, but they may have had multiple jobs in that company (i.e. they got promoted).  

So in cell F1 needs to be the date they joined their current company (in the example that should be Apr 2015), in G1 needs to be the date they started their 1st job (in the example this should be Jun 1996)

Can anyone help?
Example.xlsx
0
Introducing Cloud Class® training courses
LVL 12
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

What shortcut key(s) can be pressed to display the Windows 10 Settings screen?

Windows 10 Settings screen
0
What is the name of the file that can be run from the "Run" dialog or from a command prompt that will bring up the Windows 10 Settings screen?

Windows 10 Settings
0
Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.
0
What is the planned or expected release date for Windows Server 2019?
0
Good Day,
Can you please help,
I'm trying to get the Total Hours worked., , I'm getting 0 as a result.

I tried to divide the minutes worked / 60, I get the wrong results.

Please see sample attached
Thank you
Sample.xlsx
0
Hi

I have a worksheet with a specific character (E.g. "X")  in various cells along a row. The user has the option to hide the columns that do not apply to them (a button linked to a macro that hides the selected columns). Some of the hidden columns may contain the "X".

I am trying to use COUNTIF, COUNTA or a variation of these to count the number of cells that contain "X" in the range(D13:AR13), but ignoring the columns that have been hidden by the macro.

I have tried several suggested solutions on EE but either it ignores the hidden columns and just gives me the total number of occurrences of "X", or the wrong answer (For example, when I use =COUNTA(103,D13:AR13, I get 8 (there are actually only 7 "X"s). I have also tried using user defined functions, but these throw up 'Invalid name" errors.

I could probably do this using a macro that recounts the number of "X"s every time columns are hidden or unhidden but I'd prefer a simpler solution. Surely, it can't be that difficult to count the number of cells that contain a character, but ignore hidden columns?

The solution, whether macro driven or a formula, needs to be dynamic. I.e. when the user hides columns the new count appears instantly.

Any help greatly appreciated.

Regards

Terry
0
Hi Guys, I have an accounts spreadsheet where all the Account Numbers begin with 93 or 94 in Column A. How do I create a macro that can loop down Column A , find all the numbers in the rows that begin with 93, then multiply all the values in the same row by -1? For example, if Cell A45 = 935678, then multiply all the numbers in row 45 to the right of Column A by -1 so if B45 = 57, the result will be -57?
0
Is there any method when searching contacts to search all Outlook 2016 contact groups?

I currently have several contact groups and would like to be able to perform a search of all contacts contained within all contact groups at the same time. How can this be done?


 Outlook-contact-groups
0
Is there a way to diff check two sheets in an Excel Workbook?

More Details:

Supposed you had a a sheet A with three columns and sheet B with the same three columns.
Sheet A was created in January and sheet B was created in Febrary from sheet A. But
more rows were added to sheet B and not necessarily at the bottom. I want to
know all of the rows in sheet B which don't exist in sheet A - and if there are  rows
in sheet A that don't exist in  sheet B. How would you approach comparing the
two?
0
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Y = cleanup
N = never cleanup

i've 10,000 user exchange mailbox after compared so did and some didn't cleanup.

e.g  

Give Y when mailbox size is below 500MB that is good when user perform housekeeping by themselves
Give N when mailbox size is above or equal 500MB that tell user didn't perform housekeeping

How to compare in excel to output either Y or N.

Thanks
0
I am designing a payroll processing system and have done the backend (just a few adjustments to do one it is all finalised SLPayrollSystem2018.xlsm) and am looking at inputting and updating the information through VBA forms.  I have attached the file SLPayrollsystem2018 the one I am working on (an ongoing project).

I have put a screenshot of the user form I am working on and here is the code:

Screenshot of form in question


Private Sub cmbEditEmployees_Change()

Dim EditEmployees As Integer

If Me.cmbEditEmployees.Value = "" Then

MsgBox "EditEmployees Can Not be Blank!!!", vbExclamation, "EditEmployees"

Exit Sub

End If

EditEmployees = cmbEditEmployees.Value

On Error Resume Next

Me.tbxEmployeeID.Value = Application.WorksheetFunction.VLookup(EditEmployees, Sheets(“EmployeeDetails”).Range("B3: AD1087"), 2, 0)

Me.tbxName.Value = Application.WorksheetFunction.VLookup(EditEmployees, Sheets(“EmployeeDetails”).Range("B3:AD1087"), 3, 0)

Me.tbxAddress.Value = Application.WorksheetFunction.VLookup(EditEmployees, Sheets(“EmployeeDetails”).Range("B3:AD1087"), 4, 0)

Me.tbxNationalID.Value = Application.WorksheetFunction.VLookup(EditEmployees, Sheets(“EmployeeDetails”).Range("B3:AD1087"), 5, 0)

Me.tbxBankName.Value = Application.WorksheetFunction.VLookup(EditEmployees, Sheets(“EmployeeDetails”).Range("B3:AD1087"), 6, 0)

Me.tbxBankAccountNo.Value = Application.WorksheetFunction.VLookup(EditEmployees, Sheets(“EmployeeDetails”).Range("B3:AD1087"), 7, 0)

0
Autofilter and delete rows based on Criteria

I have two sheets in excel, I have to delete rows in sheet 1 ( column E) if the criteria is matching with Column b in sheet 2

example :

Sheet 1 Column E

ABC
DEF
FCG

Sheet 2 Column B

ABC
AFF
DEG

select entire row of ABC from sheet 1 and delete
0
Given the data in sheet-1 , the output in sheet-2 is desired for n number of entries as the button is clicked.(this is only a sample file,the original file contains 60-70 entries)
Copy-of-Macro-Sample--00000003-.xlsm
0
I had this question after viewing compare cells with each other of each row  and paste the result.
See this File  and Run the Macro
my data is in sheet3  and the result is coming to  sheet2 but i want the result to sheet4,sheet5,sheet6 and so on........
This code is working but it is pasting the result backwards in this file , I want the result in next sheet and next sheet and next sheet and so on but not in backward direction
Kindly look into it and do needful
Sample-File.xlsm
0
See this File
when i am in sheet1 and i run the code this code works
But when i am in sheet2 or in any other sheet this code is not working so kindly look into it and do needful
Sample-File.xlsm
0

Microsoft ApplicationsSponsored by jamf

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.