Hi, I'm new here and wonder if you van help me out with regard to using an array in excel.
Although I've worked with arrays before, I cannot get this one to work...

The array I need, needs to be able to do this:
- 4 dimensional, so 4 different values:
- Value 1, "WPnr": from 1 to 80 different values stored. Number field.
- Value 2, "DateCount": number of different dates. 1 number. Number field.
- Value 3, "Dates": stores the possible different dates. From 1 to 366. Date field.

I have a worksheet with 2 tabs - tab 1 has names
Tab 2 has a $total in each line, in the next row across you can pick from a dropdown box a name that is on the first tab, this follows across the line etc... at the end of the row we count how many cells contain data and this is divided into the $total a the first line to give a price per name.
Each line is the same.

What formula should I use to look up the name and sum everything....
I have used sumif, it will only work if there is one name?

Any suggestions/help most appreciated

Hi, I'm very new to VBA programming and I'm not yet able to put together a macro I need. I'm not quite sure even where to get started. I'd like to create VBA Macro that allows a blank cell to be set a value via its drop-down list then take each subsequent value selected via the same drop-down lists and append new string values only to the current the string of the same cell, and separating each new entry by ",".

I'm trying to create an if/then conditional formula that highlights the cell if the date shown is greater than 7 days past the current date. Thank you!

Can anybody tell me if I have anything wrong with this code. The Find function on the outside loop isn't finding what it's supposed to and it may be something to do with conflicting with the inside find function.

the code looks inside the 1st workbook to match variable Str and then inside the 2ndworkbook it should put the title of the row it has found the match - It calls us a function to do this. It also should count all the matches and add them together one by one in a loop. It does this loop for each sheet in the 2nd workbook. Str also changes twice from "F" to "FU".

Have code that will:
1) Look at each comment in a worksheet
2) Locate "(" and ")"
3) Decrement position from "(" until it gets to a char other than space
With those two positions, try to eliminate text between that last char and vbLF (exclusive).

The code seems to work correctly until it reaches the line containing f0605b". It can find the next "(" but cannot find the next ")".

Sub SheetCommentsNixParenths()
Dim cmt As Comment
Dim openChar As Integer
Dim closeChar As Integer
For Each cmt In ActiveSheet.Comments
CmtText = cmt.Shape.TextFrame.Characters.Text

I am using Excel 2007 on a Windows Vista Home Basic system. I am trying to format a column which contains a sum in which a cell is subtracted from another cell. I want the format of the cell to be red if the value is less than 0 and I want the format to remain black if the value is greater than 0. How can I do this?

Hi,

I need to merge two excel files into one with new column mapping - e.g. file one columns 1,3,5 to be located in columns 4,6,8 in output sheet.

As this will be done once a week, I also need to select files using a user form.

I have had a go so far and think I have come close, however it doesn't quite seem to work and I can't for the life of me figure out what's wrong with my VBA code.
The code is attached below:

Any help is MASSIVELY appreciated.

Thanks in advance,

Olivier

Can I speed up this process, not a problem for a couple of people, but if there is 150+ any help is welcome
As you can see in the pictures to get a result on the sheet 2 had to:

1. copy from sheet 1 paste special into new sheet (marked Transpose option)
2. select all cell with data and make degrees to 0
3. double center cells, modify cell to bold, font size etc...
4.repeat all for second person etc etc..

Is there any VBA or Macro to have this prosses automatically as I write data from one sheet to get a result on the sheet 2

Hello,

Hi all,
I have a payroll file made with several sheets. I store almost all data in the sheet I named Main DB. In this sheet mostly the working hours and some other attendance exceptions are calculated and converted to 0:00 time format. Then in other sheets dedicated to each month, the relevant info is extracted then the Gross and Net pay calculations are done.

I work for a rural community health center where I both help consumers choose health insurance plans (at no cost to them) and support other community assistance workers in doing the same. I am trying to create a tool that will help consumers understand how the insurance plans they are considering will operate under different scenarios of health care services.

I have 3 sheets

Sheet1 name - Demand

Sheet2 name - Collection

Sheet3 Name - Balance

Demand means A user is having some Due for a particular product Collection means the amount collected from that person for that product Balance means the person is due the rest amount i.e Balance = Demand - Collection

There are some persons also there who paid the amount more than due and those amount were kept reserved in the Column Excess Unadjusted amount in the Balance sheet.

I have about 30 tabs of data. How could I get a count of a certain code used in a certain column. I use general codes "WP","R", in column C some tabs have one row of data some have 10. Just want a consolidation page to total up the amount of each code I use. Thanks for you help.

I would like a vba script that will determine if an assembly is New or C/O based on 5 criteria.
The criteria:
1. Assembly p/n are structured like ####-AA-AA [where #### is numeric, and AA and AA could be any alpha character].
2. Block Code Assemblies p/n are structured like ####-AA-A-AA [where #### is numeric, and AA and A could be any alpha character].
3. Standard p/n are structured like 9####-##### [where # could be alphanumeric].
4. Service Assembly p/n are structured like ####-00-## and ####-01-##

I have a table with 4 rows. When I am in a cell on column B I would like a shortcut way to have the last cell entered in column c to be copied over to the new cell in column B. I have attached the spreadsheet. I know it is fairly simple to just go to the last cell in column C and copy the value and then enter into the new cell in column B. However, I am entering a lot of data and want to cut down on the number of steps it takes me. I can't have it be an automatic thing every time either because sometimes the value isn't the same.

Hello everyone,

Good day,

I have some difficulty in the match function.

when I do this it works perfectly..
=VLOOKUP($N$11,INDIRECT($AR$19),MATCH(L12&" Per meter",ACPIPESANS62HD,0))
--------------

but I have two tables the data can lay in. thus I want to make the "ACPIPESANS62HD"
dynamic.

I have a drop down menu in AR19 that "toggles" between the two tables (ACPIPESANS62 & ACPIPESANS719).
but to direct the match function's look up array, I can not seem to get the AR19&"HD" (contents set to ACPIPESANS62)to go to ACPIPESANS62HD table.

I have 3353 $ amounts from $15.59 up to $3353 I would like this on the horizontal "x" axis and I would like the quantity or frequency of occurrence on the vertical "y" axis. I have attached the data.

Please explain to an excel novice how this is done.

Many thanks
Garry

Hi,

I am new to VBA and need to create a VBA Treeform that uses parent and child nodes that when selected populates text boxes with information, drawn from excel worksheets.

The issue I'm facing is that the code I've written returns a Run-time 1004 Application Defined or Object Defined Error.

My spreadsheet contains Title headers in columns A-H, row 1 as follows - A-D, E-H, I-L and so on.
In each row underneath the headers are the names of companies correlating to the alphabetized heading - i.e. Disney would fall in the A-D heading.

Hi guys!
I have found some cool excel vba game: snake, tetris and pacman.

do you know others? the ones in this website are not so cool

My ultimate goal is to present a comparative analysis where I can EASILY show the differences and similarities between data I have assembled and data others have assembled.

I have assembled a significantly large set of data consisting of many short/succinct text strings. By contrast, other info I have is 1) data published in .pdf, .doc, .xls, other, 2) are formatted in various forms and 3) contain strings of text which are lengthy, poorly worded and of undetermined/varying lengths.

if there are a series of references from separate workbooks…

i.e. from A1-100 to B1-100 to C1-100 to D (301 workbooks/sheets in total, for example)… must workbooks B1-100 and C1-100 be opened and resaved to auto-update Workbook D when it’s opened - or when you open up D, will Excel automatically trace all the data back through the other books, even if they haven’t been opened since Workbooks A1-100 have been updated?

if I am trying to pull data from multiple workbooks to be added as rows, how can I get Excel to auto-insert the amount of rows, rather than referencing individual cells?

i.e. if the number of rows in a workbook being referenced fluctuates, I can’t simply reference cell-to-cell…

i.e. If cell A5 is set to pull in and list all data from Workbook 1, which is 50 rows - cell A6 is set to pull in and list 100 rows from Workbook 2, and A7 set to pull in 50 rows from Workbook 3 - so it all lines up nicely as 500 rows when complete…?

When referencing to another worksheet/book, is it always linked to a file on a specific hard drive (absolute) - or can be relative, looking in a certain folder, regardless of whether that folder is on computer A, B, or a cloud?

I’m guessing its probably absolute - though is there any way to change to relative?

I’m looking to design a series of templates with multiple interconnected workbooks, to be hosted on a cloud. Won’t work if the reference values are absolute - so need relative values so when linking to the other workbooks, Excel will be looking in the relative folder.

thanks!!

Commissions are paid based upon the volume generated in the past 365 days.
For example: When volume generated is between $0 - $200,000 over the last 365 days the commission level is 3%; when volume generated over the past 365 days is between $200,000 -$500,000 the commission is 4%; between $500,000 - $750,000 is 5%

Columns are:

Date Sale Price Agent

And there is a lookup table with the dollar volumes and corresponding commission rates.

It's mostly incorporating the previous 365 days from each sale date into the formula that I can't figure. Any help would be appreciated.

Hi,
I want to go to sheet2 to sheet1 by cell address. I have a cell id on sheet2 example D50 now I want to write V B A code to go sheet1 and paste amount on D10 cell . pls help me .

Hi All,

I need to calculate, how many time particular date is coming between the set of two dates.
Please find the attached excel sheet for the format.

Kindly help me to create macro for this.

Dear friend,

I run a pool billiards league where I rank the players according to games won followed by winning percentage as per the attached spreadsheet.

I would like to change the formulae to first record the highest percentage of games won PROVIDING the player has played a minimum of games... say 10.

Can you help?

Hi Folks

I need your help in automating my work which i do it in daily basis.

I have attached two spreadsheets, one "Sample_Raw Data" file which has raw data in tab 1 and steps in tab 2
Another "Sample_Final" file is the final output which looks.

https://drive.google.com/folderview?...W8&usp=sharing

Appreciate your help.

Thanks in advance.