Well and truely stuck!!!

[Brett]

Hello all.

Hoping someone out there can help with a couple of problems I'm having.
Not even sure that I can explain them properly!!!

1. Trying to find a way to use DSUM and select by two criteria from
within the equation, maybe nesting in another??

2. I'm trying to up a macro that runs of a button that will take a set
number of rows from of worksheet and then paste it into another.
However, I need the pasted(?) data to remain everytime the button is
pressed and maybe to look down the first column, find the next blank
cell and paste from there.

Not sure I explained that all too well, but any help would be
appreciated.

 

[Harlan Grove]

...
...

1. Trying to find a way to use DSUM and select by two criteria from
within the equation, maybe nesting in another??

Very likely not possible using DSUM. You can always use references to larger
criteria ranges as the 3rd argument, so it appears you want more flexibility
than that. Show us your formula and the criteria you want to use. There's likely
a work-around, but it's not worth guessing based on zero details.

2. I'm trying to up a macro that runs of a button that will take a set
number of rows from of worksheet and then paste it into another.
However, I need the pasted(?) data to remain everytime the button is
pressed and maybe to look down the first column, find the next blank
cell and paste from there.

If the source range that's copied is always the same, and you want to append it
below already copied data, try something like

SourceRange.Copy Destination:=TopOfDestinationRange.End(xlDown).Offset(1, 0)

 

[Brett]

Thanks for the reply

I need the equation to look at two different variable data cells o
different worksheets then look at the database and sum the matches
Could get it to work fine with just the one. Not sure what you mean b
using references - can you explain further?

For the macro I'm afraid that I don't write them, just record the mous
clicks - beginners method!! How would I incorporate your suggeste
line. You have explained exactly what I'm trying to do. I've pasted i
a simple example of how my macro looks. Can "SourceRange.Cop
Destination:=TopOfDestinationRange.End(xlDown).Offset(1, 0)" be added?

Range("A1:A5").Select
Selection.Copy
Sheets("Sheet3").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
Sheets("Sheet2").Select
Application.CutCopyMode = False
Range("A1").Select
End Sub

Thanks again for your time