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

I have a spreadsheet that gets opened automatically every day to pull data from other sources. I have a list of dates for every work day for the year in column A. In column B in the first row I have a formula to start. None of the other rows in column B have this formula yet. What I need to do is when the file is opened every morning automatically I need the formula to be copied down to the row that has the current date in column A and then paste the values in the row where the copy originated from. For example if A1 is 1/17/18 and the formula is in B1 I need to take that formula and copy it to B2 since A2 is 1/18/18. And then paste the value that is already in B1 so the formula is no more in B1 and is now in B2. How can this be done in VBA?
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.

Hi all,

Attached is a spreadsheet where numbers will be added into the tab "Data_Tab", i need those numbers to displayed in tab "overview"

The numbers i need filled in tab overview are highlighted red, they need to be matched via type eg "Z Read" and date "01/01/2018"

Attached is the spreadsheet  I am using

Thanks
Seamus
HOWL-REPORT.xlsx
0
Have this solution

then


need get like this

090909090990909090909090909090909909.PNG5653247890344.xlsm
0
looking for V_OUT sheet

for example im looking for 65 it appear 8 times

but when hit find 2 it only show 3 times
65434677665.xlsm
0
have this solution need can button to clean the HIST_DTA
29078876--2-23421.xlsm
0
need create an history to be show  in HIST_DTA






of the selected  i mean to compare ( what  need to be selected )

888888888888888888888888888888888888.PNG29078859b.xlsm
0
1-need the find numbers be show as the result is  show  in A4   V_OUT sheet

2-need show the total columns od data in b1  V_OUT


666666666666666666666666666666666666.PNG8598744458.xlsm
0
A client of mine gets the error at home while on VPN. We use Pulse Secure VPN. Any ideas on how to fix this?
0
have this solution but then  need to count the coulmns with data

also
when an number appear need be color green the cell

5555555.PNG456778654.xlsm
0
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
[Webinar] Database Backup and Recovery
LVL 11
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

I am banging my head against the wall on this one. I know I am missing something. I can search an email in the inbox, BUT I cannot scroll to that date and time and find it. Any ideas?
0
When attempting to save multiple attachments from an email nothing happens. As seen in the screenshot I can select multiple attachments but the will not save locally or to a network share. I can save single attachments with no problem. Anyone know what the issue is?
Capture.JPG
0
Our company have got new project for CRM dynamics and customer is asking to get involved in Hardware sizing. We are new to this topic, can anyone help me with some basic guidelines, templates etc. please?
0
We offer a recycling service and all our customers receive their pick up dates by email once they sign up for a contract.
The data is saved in a worksheet ("RecyclingTax").

I have been asked to display the current week's pickup in a separate worksheet. Obviously, this is a task for the advanced filter.

I do have difficulties making it work. Maybe it is because of the way I put in the criterias?
What is the correct procedure to make it work?

screengrab.PNG
The only reference to a customer in the "RecyclingTaxi" sheet is the customer ID.
I would have to use a VLOOKUP or similar to get the customer's address as well.  
Is it possible to put the filtered data into a table/listobject and then make use of the VLOOKUP?

screengrab2.PNG
Thanks for helping me make the advanced filter work.
sample.xlsm
0
transfer cd  to  usb  drive
0
I have tried a variety of ways to get running totals in my pivot table.  It works fine for a standard sum.  The variable dataField contains the value "Ledg Amt", which is extracted from my pivot definition table.  When I type the code in my project, I get no red lines.  It seems to be the correct syntax, but when I run it then I get an error.  

No Error - This works fine
                                            pivotTable.AddDataField(dataField,
                                                pivotData + " Summary",
                                                XlConsolidationFunction.xlSum).NumberFormat = "#,###";

Error:  Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
 
                                           pivotTable.AddDataField(dataField,
                                                pivotData + " Summary",
                                                XlPivotFieldCalculation.xlRunningTotal);

Error:  PivotFields method of PivotTable class failed

                                            pivotTable.PivotFields(dataField).ShowDataAs =
                                                XlPivotFieldCalculation.xlRunningTotal;

Error:  'System._ComObject' does not contain a definition for 'ShowDataAs'

                                          pivotTable.PivotFields(dataField.Name).ShowDataAs =
                                                XlPivotFieldCalculation.xlRunningTotal;

Error:  PivotFields method of …
0
If a cell contains the word "Yes" (with a few other words in it), we want it it to be "Counted". What would the "countif" be?

We actually will be using the formula for excel and for Google Docs. Is that possible?
0
I have a spreadsheet that has different width and sizes columns and  , when I copy and paste the Data into a new spreadsheet the pasted contents does not come as the original, some information shows ########## even though the previous row shows the right numbers.
Thanks a million!
0
have this solution
then need

have row 25 be show in N_Space sheet

aaaaaaaaaaaaaaaabbbbbbbb.PNG

bbbbbbbbbbb.PNG234556.xlsm
0
Granular recovery for Microsoft Exchange
LVL 1
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

I have worksheets named WS1 and WS2. I need to compare Column C of WS1 with Column D of WS2. If both columns contain same values then I need to highlight both the cells of "Column C of WS1" and "Column D of WS2".
Example:
Column C of WS1    
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
2,520.16
30,000.00
210,000.00
650,000.00
10,000.00

Column D of WS2
2520.16
500,000.00
260,000.00
65,000.00
30,000.00
46,104.00
530,000.00
350,000.00
55,000.00
7,000.00
30,000.00
1,827,099.63
210,000.00
650,000.00
10,000.00
If values of Column C = Value of Column D then the cell containing same values in both columns is highlighted. My data is not uniform. They may have repetitive values. I am doing it manually right now and it is time-consuming as I have a lot of data to work on. Can you please suggest me.
 I am looking for exact matches for currency amounts and also I want the amounts which has been already matched to be left out. The value in each cell should be matched with only one value of another cell. Leave out the next repeated value to match with next.
0
have this

error in code to run

a1a2a1.PNG123456.xlsm
0
Hi
 I was just reading a solution explained by our member Saqib Husain, Syed in the thread https://www.experts-exchange.com/questions/28654243/Copy-data-from-Main-Sheet-to-multiple-sheets-based-on-a-criteria.html
 I have a similar situation with excel 2013. I already sent a message to Syed with my request but not sure whether Syed is still active in this forum. Would anyone be able to help?

 I would like to have a Macro in the ‘Task Allocation’ sheet to copy the rows from Column B to Column G and paste it to the individual ‘Team WiP’ sheet as per selection from the drop down list from column A in Sheet-‘Task Allocation’.

 The selection of rows starts from row 6 only as row # 5 is the header

 The entries in the ‘Task Allocation’ sheet need to be cut and copied across to the relevant sheets as per selection from column A.

 As an example, if I select ‘Team 1’ from the dropdown list, the entire data on that row from column B to G need to be copied in to ‘Team1 WiP’ sheet. If there are more allocation to Team 1 from the Task allocation sheet, it would be copied to the next available row in the individual team sheet. Similarly, If I select Team 2, then the data will be copied to ‘Team2 WiP’ sheet. I have 6 teams to select from.

 I have attached my sample file and the code I have which is not working is pasted below

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("A6:A" & Range("B" & Rows.Count).End(xlUp).Row)) Is Nothing

Open in new window

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

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.