Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x

Microsoft Applications

43K

Solutions

37K

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

each column have  numbers

V_OUT sheet is where to work with
 

example  03  in each column  
 show the count by column in row 6 above the column
then the total count in b6

AAAA23123.PNG674398_out.xlsm
0
Free Tool: SSL Checker
LVL 11
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

have this solution
then need

have row 25 be show in N_Space sheet

aaaaaaaaaaaaaaaabbbbbbbb.PNG

bbbbbbbbbbb.PNG234556.xlsm
0
have this

error in code to run

a1a2a1.PNG123456.xlsm
0
HI Subodh or others ..

Subodh helped me with this and it worked great but can this be modified so that it looks in column B and it only copies the items with items in column B that have 10 characters ?

so if Column B has items with 10 characters , I need only those copied to the new file.
If it helps , all those items in Column B start with XX\    and then seven characters

So if it matches the above then only those will copy Column A and B to the new files.




Sub SplitFile()
Dim swb As Workbook, wb As Workbook
Dim sws As Worksheet, dws As Worksheet
Dim lr As Long, i As Long
Dim FilePath As String, FileName As String
Application.ScreenUpdating = False

Set swb = ThisWorkbook          'Source Workbook
Set sws = swb.Sheets("Sheet1")  'Source Sheet
FilePath = swb.Path & "\"

lr = sws.Cells(Rows.Count, 1).End(xlUp).Row
For i = 2 To lr Step 10000
    Set wb = Workbooks.Add
    Set dws = wb.Sheets(1)
    FileName = i & " - " & i + 10000 - 1
    dws.Name = FileName
    sws.Range("A1:B1").Copy dws.Range("A1")
    sws.Range("A" & i).Resize(10000, 2).Copy dws.Range("A2")
    Application.DisplayAlerts = False
    wb.SaveAs FilePath & FileName, 51
    wb.Close True
Next i
Application.ScreenUpdating = True
MsgBox "Task completed!", vbInformation
End Sub

Open in new window

0
Hi EE

I have an Excel file with 100,000 line items with two columns .
Does anyone know how I can separate that into 10 files with 10,000 line items each ?
0
Hi

I'm trying to create a formula that will look at two columns and then add up the 3rd column if both criteria are met.

Screenshot of Excel sheet
I've used SUMIF before which has always worked but I'm unable to get this working.

What I would like to do is for Excel to look at Column E for CFT1000, then if Column G matches FPUP01 it then adds all values in Column J together.

Thanks
0
Hi

I need excel formula or VBA.

I need extract between "MeContext=" and  ","  result should be in B1=CLWRFLSRBBU04124

and same need to be extract between "EFDD=" and "," result should be in C1=CLWRFLSRBB434411

A1=Frame=r,SubNetwork=Tam,MeContext=CLWRFLSRBBU04124,ME=1,EF=1,EFDD=CLWRFLSRBB434411,ER=8565
 B1 = CLWRFLSRBBU04124
C1 = CLWRFLSRBB434411
0
I have many worksheets that are structured the same. On each worksheet there is a tab called "Tax". On this tab,  I want to change the contents in cell E91 from 0.00% to 17.77%. Is there code that can 1) allow me to select various worksheets 2) open the first worksheet make the change save and close the worksheet 3) Open the next worksheet and do the change and save until all the worksheet selected have been completed?

Thank you.

Conernesto
0
NEED HAVE AN selector for when is an complete task



and change the color

have to be in column B
23455.xlsm
0
need to open some  data books  

but want to use the relative path

not the full path

but is not opening why ??
0
Free Tool: Site Down Detector
LVL 11
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.

to always open  in the last week

here the file
29076215a--6-_87878.xlsm
0
Hi,

We use this formula to get the occurrence of items within a column ("=SUM(IF(FREQUENCY(MATCH(B10:B64781,B10:B64781,0),MATCH(B10:B64781,B10:B64781,0))>0,1))").  However, we need to place filters in the columns and want to reflect the occurrence as the items being filtered.  We took a look at "=SUBTOTAL" but can't get it work as we want it.

Is there a way to this?
0
I have other situatin with this file

need have the Fill BLANK cell Button and function working in DTA sheet

( this button puts an Non Print character in the blanks cell  so i can work with the data

need be in DTA because need  that before anything else  when needed
( rigth now is in the last step)
890765.xlsm
0
have this solution working

then

1- DTA sheet  clean button don't clean data in row 47 and 46   need clean

2-LINE OUT sheet  need button to clean data and format column B

3-N_spaces sheet need an  button to clean data area  (need clean data and format)
09876.xlsm
0
See Attached sheet.

I have placed conditional formatting on a date column to change colors as the date gets closer to today.

However I would like for the BLANK cells to remain unformatted. So if there is nothing in the cell or it is blank then it should not have any formatting on it - it should be white with black text.
HoneyDoList.xlsx
0
try to run from an button but don't run

why?

Dim sResult As String
  On Error Resume Next 'Blanket error handling
  
  'Display inputbox to prompt user for row/column
  sResult = InputBox("Type a row number or column letter and press Enter.", "Jump To...")
  
  If IsNumeric(sResult) Then 'Select row
    Cells(sResult, ActiveCell.Column).Select
  Else 'Select column
    Cells(ActiveCell.Row, sResult).Select
  End If

Open in new window

0
BUTTON TO CLEAN DATA
IN COLUMN B

CLEAN data and format Please!!
4567.xlsm
0
Microsoft OneDrive (home ed). Windows 10.
I want to add 500 photographs to my OneDrive Account. Is there any quick way of adding these apart from uploading the files from  the folder in my computer where they are stored. I wonder is there any program which might do this?
0
Hi, I created several folders under my inbox in Microsoft Outlook and would like to create rules that would automatically put incoming mail in them but when I try to do that, they don't show up in the directory.  Only the default folders show up. See pic 1.  Is there a way to do that?
ThanksDirectory
0
Efficient way to get backups off site to Azure
LVL 1
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

button to create the  Week date  am/pm and relative spaces

AQWE2.PNG29076215a--2-.xlsm
0
have this solution then an button

need to

1- move to the last coulmn with data

2- goes to first column
12345098.xlsm
0
have this solution working as needed

then need an button  to

go to the next week each time the button is clicked backward
087234.xlsm
0
I am using a windows 10 64 bit home edition. I have an annual subscription to Office 365. I have 5 licenses available.

I was getting error messages relating to a word addin so i decided to re install office 365.

I uninstalled office365. I downloaded the latest installer from my account subscription. I ran it as administrator.

When i go to launch word it, it hangs at the start up.

When I use /safe switch it opens okay but requires that i sign into my personal microsoft account.

If I choose to not sign in then it asks me for an Office 2016 registration key. Which i do not have since i am on subscription.

However, when i click the to sign in i can get past authentication but the process hangs at the Getting Office Ready for You pop up notice.

Instead of paying "microsoft Experts" to answer my problem I decided to return to experts exchange for help. Hopefully, someone out there know i way i can fix this. I am essentially without my offce programs and I need to access to my documents ASAP.

Also, if someone can point in the right direction to get support directly from microsoft without having to pay a lot of money that will help to.
0
1-button to navigate to top of the sheet

2- button to navigate to an specific cell
0
have this solution working as needed
then need an clean button to
change faster data as need
29076029__L_a.xlsm
0

Microsoft Applications

43K

Solutions

37K

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.