Simplified formula to move data from one sheet to the next available row or cell of another sheet when a number is entered into a cell range?

Help! I created a Gantt chart to reflect deadlines over the next 5 years. With so many tasks/items listed in the y axis, Excel is reformatting the chart to only show the first 8 items. I want to show all items in the y axis - even if the chart needs to be huge. I've tried adjusting the axis interval (configured as text), min, and max values, as well as the font, but the chart only shows a portion of the total data. Any help would be appreciated. Emily

Good day

I have a document (attached) with various sheets each containing a number of charts and data ranges. Initially the charts were working fine, but of late it is almost as if the charts do not exist, even though they are displayed. When I select and copy a chart, it is not copied to the clipboard and therefore cannot be pasted. If I create a new chart using the same data ranges as one of the others, it looks the same and acts normal ( I can select, copy and paste it).

I am trying to code standard normal with standard deviation of (3) and NormalMean = (31).

I am very new at this any suggestions would be greatly appreciated. Here is what I have so far:

Sub NormalDist(z)
Dim NormalMean As Integer
Dim NormalSD As Integer
Dim x As Integer

x = 31
NormalMean = 31
NormalSD = 3
N = 10

NormDist(z)= (31,31,1)
Cells(3, 3).Value = NormDist

End Sub

Hello Guys,

I have 2 files both have data actually I am getting file everyday,
We will call Yesterday file (File1.xlsx) and Today's file (File2.xlsx), both have some fields like prodcutId, Price Quantity and more

We have 2 fields are important here... 1) ProductId and 2)Quantity

Macro done be for like : Open both file and copy data from File1 (Yesterday's)file and paste into File2 (Today's File)

hi i was actually looking for help in this code i got from vba forum by so
It does not seem to work on my pc. i have attached the excel. i have mentioned the details in sheet1 and in sheet2 the screenshot
Sub SO()

Const Q As String = """"
CreateObject("WScript.Shell").Run "CMD /C ROBOCOPY " & Q & Range("A6").Value & Q & " " & Q & Range("C6").Value & Q, False, 0

End Sub

many thanks in advance

I am trying to identify common themes from free-form text extracted from a case management system. I found a VBA macro that analyzes free-form text and counts the frequency of each word. However, the requirement is analyze free-form text and count the frequency of common phrases.

Anyone know of a VBA macro or built-in function that can do this? Or, can I modify the VBA macro below to do what I'm looking for?

Sub MakeWordList()
Dim InputSheet As Worksheet
Dim WordListSheet As Worksheet
Dim PuncChars As Variant, x As Variant
Dim i As Long, r As Long

I have a sales report containing active customers from the database and prospective customers added by the salespeople.
I want to protect the active customers' names. So, I need a macro that:
If cell in the ""Status"" column does not contain the word ""New Prospect"" (there may be other words in this cell), then protect the cell in the ""Customer Name"" column.
Naturally, it needs to search all rows. The number of rows will vary per report. "

Hello,

Please see an attached spreadsheet that contains a Macro that will run a VLookUp to seek for the matched values. The unmatached values will come as #N/A. The goal is to after running the macro to not only find the matched and unmatched values but to copy and paste the unamatched values in another sheet.

What I am trying to achieve here is VBA code as I don't think I can work this up using excel formulas.

I have two tabs "Data Tab" and "Summary" that I am working with. All of my Data is consolidated on one sheet called "Data Tab" and the data on the "Data Tab" worksheet is all from formulas that check if cells are blank in different areas of the workbook. If they are not blank they are copied to the "Data Tab" worksheet.

All,
We have the ability to print and export Quickbooks Enterprise Data into excel. However, we want to compare the years 13, 14 and 15. However, the customer names can be on 1 or more of the lists or not at all. Can someone be kind and point in the the right direction as to having 3 tabs or data, same fields, different year end date and place on a new tab.

CUSTOMER 13 | 14 | 15 |

Hopefully all customers will be listed and the sales totals would be in each of the respected cells.

I sure appreciate it.

Michael

Hi,

I am working on a formula to compare two sets of columns and, if there is a match, to copy data from a specific cell. So far my formula looks like this:

=IFERROR(IF(INDEX($I$2:$I$5,MATCH(A2&B2&C2,$F$2:$F$5&$G$2:$G$5&$H$2:$H$5,0))="","",INDEX($I$2:$I$5,MATCH(A2&B2&C2,$F$2:$F$5&$G$2:$G$5&$H$2:$H$5,0))),"")

....I've attached an example sheet and what i'm after is that if there is a match between A/B/C column when compared to F/G/H columns then it returns the corresponding cell from column i into column D.

Hello,

I am looking to convert information from a website to Excel. I am using the following website: http://hansard.millbanksystems.com/commons/ This is the website for the UK Parliament.

My spreadsheet has 5 worksheets within it. The first one is where I want all information to end up.

I have the main spreadsheet with item numbers in Column A and price in column B( called furniture contract). I have four other worksheets within this spreadsheet (MF, MZ, 5G, MX). Each worksheet has item numbers (excess of 4000+)in Column A and a sell price in Column C.

This is a corrupt file!

I have tried various ways to open this file but no joy!
I can't open it at all.

Can anyone suggest a method to see/fix this spreadsheet.

Thanks,

I have a spread sheet that tracks client visits, and am looking for the best way to track multiple visit dates without using a cell for each date. Is it possible to enter a date in a cell, then next month, have another date entered in the same cell creating a drop down for me to click to view all visits?

Thanks!

Hi I am working on a priority list and encountered some problems with it. I would really appreciate all the help, thanks.

What I am trying to do is to have excel automatically assign a specific number to the Urgency Column based on how many days the item is from the Due Date.

Priority SN Importance Effort Urgency Due
6 .. A 1 1 3/26/2015

So I want the Urgency column show the following number if the following is true
1 - if today is passed the due date
2 - if today is the due date
3 - if the due date is in 1 to 3 days
4 - if the due date is in 4-5 days

I have 2 files in excel that are .xlsx format. They were both corrupted somehow I don't know and both are so far unrecoverable. The things I have tried so far:
the error is: Excel cannot open the file 'blah.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

Changing file format to xls or xlsm .
Using excel's open and repair method, including the extract data method
The "Recovery Toolbox" program
Microsoft recommended options:
Set the calculation option to manual

I'm not sure if what I am trying to do is possible or not. If it is I can't seem to figure out how to do it. Basically what I am trying to do is if H1 contains an "x" AND there is any text at all in A1 I want the H1 to highlight green. If there is no x in H1 and there is any text in A1 I want the H1 to highlight red. I've already used conditional formatting to highlight green when there is an X the problem is I would like to be able to highlight red if there is no x without it highlighting the entire column even if there is no text in A.

Hi All

I have created a database in excel that contains a list of materials with min and max widths, thicknesses, weight and quantities in it.

I have a search form that the users can type in the min and max amounts (restricted to numbers) that excludes rows accordingly to meet this criteria.

So far I can get it to work if they put a min OR a max in (leaving the other option blank)

what I am struggling with is how to add in the rule - if they select both a min and max
Everything I've tried so far doesnt work, but coding is by no means something I do very often or very much of.

Excel wait symbol not showing in Mac 2011 excel.. application.cursor=xlwait

Please help on this

Have a spreadsheet that has information that is needed for our sharepoint site. I have figured out how to open the sharepoint site when the user clicks submit but I am having a difficult time importing cell information into sharepoint. For example on the the sharepoint for the title should come from Sheet1A2 and so one. Thanks

I am wondering how to format this data below to show multiple lines in an excel chart. The only way i have found how to do it is to create multiple label columns and put the counts under each label for the specific date. Is there an easier way?

Date Label1 Count
3/17/2015 0:00 1111 122
3/18/2015 0:00 1111 123
3/19/2015 0:00 1111 113
3/20/2015 0:00 1111 113
3/21/2015 0:00 1111 105
3/19/2015 0:00 2222 5
3/20/2015 0:00 2222 1
3/17/2015 0:00 3333 213
3/18/2015 0:00 3333 213
3/19/2015 0:00 3333 202
3/20/2015 0:00 3333 209
3/21/2015 0:00 3333 172
3/17/2015 0:00 4444 23

I have an excel sheet with names and data associated with the names. Few names occur only once in the sheet and a few occur twice and few thrice. Is it possible to gather all the names based on the number of times it occurs in the document?

Appreciate your time and help

Thank you

New to this forum, looking for some assistance.

I have a user form to enter truck order information. In a text box I enter the order #,
I want to be able to enter order # 1 up to order # 10

When I select add order to daily order I want the information added to worksheet tab daily order in the correct order # row.

I also would like the row background color to red indicating if order was received after 2:00 pm.

Thanks for any help on this

Hi ...

It is pretty urgent and requesting you to give me a solution on the following issues im facing with Excel:

1. There are 3 columns(A, B & C) and in each column, i have five cells(rows) with some text on top of which i have added Radio buttons on all those cells. It is like when someone click on the second cell(A2's radio button), then the value '2' should display in the resultant final cell(which is 6th cell on the same column). Likewise, i have five radio buttons in each column with one final resultant cell to display the value. (Please refer the attached IMAGE) ...

How can I split a huge table into separate workbooks by Salesperson, but keep the formulas & formatting?
Pivot table won't work because it changes the format of my master worksheet.
Tried a macro I found online and Ablebits Split table tool, but neither copies the formulas.
Right now, I'm filtering and then copy paste. blek

Hello everyone!
When trying to create a chart with information trending over a long period of time I keep receiving this error message:
"The maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series."

What can I do to stop this error?

Regards

Why does a 15 digit number display as typed and a 16 digit number changes the last digit to 0?

How to cure the problem not using text format.

2 advanced filter in same active workbook

WHERE ?
My data range is in Sheet.(Num)
My dynamic criteria is in Sheet.(criteria)
I do not need to copy my extract anywhere else , just need to count the special cells displayed.

WHAT is the PROCESS ?
There are two advanced filters in my code . Lets call them AdvancedFilter1 & AdvancedFilter2
My criteria is dynamic but with the same headings . So for both the advanced filter the headings of criteria are same , only the data below them changes.