Hi There

I would like to create a table which reports values from various sheets, depending on which options I select for the table in the form.
In the attached example I have sales data on three sheets: Cheese, Milk and Yoghurt. The format of each sheet is exactly the same, only the Brand Names are different (although I have the same number of brands on each sheet).
I want to create a summary table on Sheet 1, where I can select a parameter in each of the yellow highlighted cells (I would like this to be form controls), and it should return a table for me.

How to insert elbow connector across 3 excel charts and put into word doc?

I can put the elbow connector line across the charts in excel but when i try to do this in word the elbow connector can only stay within one chart . It will not let me move the connector across all 3 charts.
Any ideas?

Hi all,

I'm looking for way to extract only the info i need from a given row:

This is what i have:

Paraguay;17/03/2013 @ 19:53;Binbit;Buzzcity;Pending;$0.7;Pack3;063593will2410f00257
Paraguay;17/03/2013 @ 19:33;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc240c64256c
Paraguay;17/03/2013 @ 19:15;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc23081a0c6d
Paraguay;17/03/2013 @ 18:04;Binbit;Buzzcity;Pending;$0.7;Text2;063bfc24f75af222
Paraguay;17/03/2013 @ 17:52;Binbit;Buzzcity;Pending;$0.7;Pack2;06357923f497133e
Paraguay;17/03/2013 @ 17:19;Binbit;Buzzcity;Pending;$0.7;Text3;063c0624ecdcebc5

I'm a newbie to VBA so please be patient.
I have a live data feed in cell D18 and it's changing constantly though my aim is to capture the first time it populates(first Event) with a number each morning and copy it into cell F18(locked down)...the code below captures "every" change(event)in the cell though all I need is the first change then to exit the sub completely?

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Range("D18"), Target) Is Nothing Then
'MsgBox "D18 has changed"
Range("F18").Value = Target
End If
End Sub

Hi All,

I am not able to get what i want to be from this code, this did not give me any error, however it also did not solve my purpose. there might be something with the line: Rng = ("A" & i & ":" & "D" & i). please help.

Sub test()

Dim FindString As String
Dim Rng As Range
Dim c As Range

Dim i As Integer

i = 1 'start row number

For Each c In Range(ActiveSheet.Range("C1"), ActiveSheet.Range("C65536").End(xlUp)).Cells

If Cells(i, 3) = "abcd 1234 POSTED TO G/L" Then

Rng = ("A" & i & ":" & "D" & i)

Rng.Interior.ColorIndex = 4

Hi,
I am a Belgian, dutch speeking person, so forgive me if I cannot express me clearly in English. Furthermore I am a starter in using VBA in excel, so please don't answer too technically for I might not understand your good work you are doing for me. I appreciate your help with the next topic.

Attached find workbook "code2" / Sheet2 combobox /
property 1. ListFillRange = named tablerange "code" from Sheet code!
property 2. Linkedcell = A4

I am trying to have following return thanks to some VBA code.
1. IF records from column "code" in table are added or deleted,

See attached file... No macros involved, just Match and offset formulas.

I have 2 databases I created in Excel. Database #1 is used by a person to scan in transactions daily. Each scan registers the date of the scan in column A, column B shows the number of cartons and column C shows the number of lines.
The second database is the master database that shows information from the first database and 2 others. The information gets uploaded each time the "master" database is opened.

Hello Admins,

I am new to VBA and know just the basics of VBA.I have been given a complex task to make a MACRO for organisation. details are as

There are following designations
Designation reports to
Manager top
Operation manager(OM) reports to manager
Engineer manager(EM) reports to Operation manager

Hi friends

i have an employee data for shift scheduling
which should work automatically.
i need this data in special format which i have shown in attached excel file

pls help

regards
Killerware

Hi

Can someone help me to make some formulas to calculate overtime based on the following :-

weekdays including saturdays, overtime is paid 1.5x up to 2300 and beyound 2300 its 2x
and for sundays and public holidays overtime is paid for the first 8 hours its 2x and beyound 8 hours its 3x

thanks

Hi

I have the below data.

Brand Country Amount
1 400 100
1 401 150
2 400 200

I created the below pivot table.

Row Labels Sum of Amount
1 250
400 100
401 150
2 200
400 200
Grand Total 450

Hi,

Unfortunately in this economic climate, too many businesses are closing up shop. With this said, the software I currently uses pushes reports out in Excel 2003 that are digitally signed. As the company has gone out of business, is there a way to resign the reports? I do not have the original key to take their digital signature off, but I have purchased my own digital signature. Can someone please explain the best course of action or any suggestions as to what I should do?

THANKS!

Hi, running some Excel sheets and unable to save the sheet, receiving message "Excel cannot complete this task with available resource. Choose less data or close other applications." I am not running any other applications and tried to clear RAM using ASC but still getting the message. Any idea how I can save the file without losing it. Thanks.

Hi,

I have chanced upon this forum and decided to join as I believe in its success.

Please refer to the link for reference.
https://www.dropbox.com/s/0kmpjes783lgju7/Shift-scheduling.xlsx

I am having trouble with shift scheduling and will greatly appreciate any form of solutions/suggestions.

I will need a formula that's able to produce the names available for the camp (reflected in Cell K2). So as such, when K2 changes, the list (Cell K5 onwards) of people available changes too.

Any inputs or suggestions as to how to approach it? Thank you very much!!!

Sorry everybody but when I thought I was getting to grasps with this it's all going down the hill.

The code bellow checks for;

W17 which is a delivery date field. This is working correct. It displays message if date is in the past.

Now the problem is, if date is in the past I get message and if ok then the macro runs to the next step and checks for cell AX17 processed by.

Now if date is not in the past the macro does not carries on to check AX17, it just stops...

Where in the code bellow am I going wrong please?

Thank you.

Albert

Hello,
I am attempting to calculate standard deviations separately for different conditions (the equivalent of the AVERAGEIF function but for standard deviations).

Sheet 1, Column F contains which condition the row is (values = 0, 0.5, 0.75, etc.)
Sheet 1, Column G contains the data I want to calculate standard deviations with
Sheet 2, Column A specifies the conditions (values = 0, 0.5, 0.75, etc)

The following array formula seems to be working:
=STDEV(IF(sheet1!F:F=sheet2!A3,sheet1!G:G))

Hi.

I have tested the following macro which works to an extent.

[quote] Dim r As Range

Const MySheet = "Sheet1"
Const MyRange = "A10:B45"

Set r = Worksheets(MySheet).Range(MyRange)

If Application.WorksheetFunction.Count(r.Columns(2)) < _
Application.WorksheetFunction.CountA(r.Columns(1)) Then
MsgBox "Qty missing!", vbInformation
On Error Resume Next
Application.Goto r.Columns(2).SpecialCells(4)
On Error GoTo 0
Cancel = True
End If[quote]

hi, to try this you need to create 2 new excel files (a.xls , b.xls), each containg 1 worksheet, and 1 word file.
copy the following code to the word file :
===================================================
''make reference to Microsoft Execl Object Library
Private Sub Document_Open()
Dim wbA As Excel.Workbook
Dim wbB As Excel.Workbook

Set wbA = GetObject(ThisDocument.Path & "\a.xls")
Set wbB = GetObject(ThisDocument.Path & "\b.xls")

wbA.Worksheets(1).Range("A1:Z100").Copy wbB.Worksheets(1).Range("A1:Z100")

wbA.Close False

Hello,

In cells A40 - A47, the following formulas are contained:
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 1-200'!$F$1:$G$700,2,FALSE)
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 201-400'!$F$1:$G$700,2,FALSE)
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 401-600'!$F$1:$G$700,2,FALSE)
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 601-800'!$F$1:$G$700,2,FALSE)
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 801-1000'!$F$1:$G$700,2,FALSE)
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 1000-1200'!$F$1:$G$700,2,FALSE)
=VLOOKUP(B3,'[Ebay Stock Sheet.xlsx]LISTINGS 1201-1400'!$F$1:$G$700,2,FALSE)

HI Y LIKE TO KNOW THE PROGRAM TO SOLVE MATRICES WITH THE TETHOD OF GAUSS SEIDEL AND HAW TO USED THANKS I REALLY DONT KNOW HOW

Hi there,

Im a beginner using VBA but guess my question would be a more advanced subject.

I have a stock price trading indicator inputting data into column L each minute. This indicator oscillates positive to negative around 0 as below:

6.4453125
8.333333333
10.546875
12.890625
15.234375
14.296875
11.640625
9.84375
8.515625
6.822916667
4.31640625
1.630859375
-0.908203125
-0.384114583
1.325954861
1.81640625

Hi all,

I hope I’m posting this question in the right place.

I have been trying for a while to automate a process that takes a lot of my time without success. I work for a non-for-profit org and we try to allocating preference ranked choices to pre-ranked clients offering each client his or her highest available choice and have a standby clients in case one of the clients withdraws.

Hello all,

First of all, I apologise if I have registered myself on a forum purely for experts interested in advance use of Excel. I'm afraid I only use it for very basic things in comparison!

I have recently been experimenting with a basic financial spreadsheet to keep a running log of costs over six categories per month, with each category named at the top of the sheet. At the bottom there is a running total column for each category.

Hi all,
I am creating an Excel database. I would like to import names, emails and job positions of all employees of a private company from the firm website.
I chose Data->From Web and selected the whole page, as only one yellow icon to select data was available. In fact no table for the above data is present: just a quite big webpage with photos of employees and names, emails, job positions next to them.

Ok, i have this problem that i can not figure out for the life of me.

I have a pivot table. In the row data i have the months. No problem here.

In the column data I have projects and in the data fields are the costs of those projects. Again, no problem here.

Suppose i have 4 columns in the pivot table labeled Project A, Project B, Project C and Project D. again, no problem here.

I create a pivot chart based on the table data fine. The chart is a shale, or area chart with stacked areas on on the other.

I want to them to appear in the same order as they do in the pivot table...

Hi All,

my problem is that i want to colour the row containg text "POSTED TO G/L" and above 3 rows i.e, whichever row contains "POSTED TO G/L" that row and above 3 rows are to be coloured using conditional formating.

NOTE: The text "POSTED TO G/L" appears in only coloumn A.

any help regarding this would be apprerciated.

thanks in advance

Regards,
Manish

Hi expert,

question: there is a command button in a sheet and some data. on the 1st
click on command button i want to select range a1:d12 on the second click
deselect the previous selection and select range a13:d24 and at last on the
3rd click select the range a25:d36.

i am tying to code it in VB.

can you help me out.

Regards
Anish