Posts by Brand_New2VBA

Brand_New2VBA · May 23rd 2011

Re: Execute code based on specific text in target range of cells

Hi Ed,

Thanks so much for the information.

Yes, I understood the codes you gave me, however I'm still trying to understand how to apply them properly.
So far I've been getting alone quite well and these are the only issues left.
Sheet 1= "Upcoming Workflow" tab
Sheet 2= "Calendar"
Sheet 3= "Future Workflow"
Sheet 4= "2011 Published Workflow"

On Sheet 1 I have 3 main buttons. Right now the only issue I have is the "Published Workflow" button. I need the information that is cut from column C to be pasted into Sheet 4 under its respective month (according to the intended publication date"). Also I'd like --on sheet 3--for the information copied from column 3 to be pasted in sheet 1 under their respective month.

Is there a macro that can tell excel to paste the information being copied under the month indicated in the "intended publication date" queue?

Brand_New2VBA · May 18th 2011

Re: Execute code based on specific text in target range of cells

Hi Ed,

Thanks so much for replying. Ive attached a sample of the project im working on.

If--for instance-- on sheet 1 range b4:e4 has the word "published" written in it then i want the info in range c5:c10 to be copied into the next available queue on sheet 4 (under its respective month) and the whole range b4:e11 to be deleted and the next queue shifts up. all with the click of the published button.

Here's the sample file
forum.ozgrid.com/index.php?attachment/38373/

Brand_New2VBA · May 18th 2011

Re: Designate copy and paste values to specific areas (indicated by name of column

forum.ozgrid.com/index.php?attachment/38361/

Hi,

Thanks for responding. I've attached a sample file. Hope this makes things clear. I'd like information copied from the "Future Workflow" tab to be pasted in the "Upcoming Workflow" Tab according to the month placed in the intended publication date--in this instance May and June. So if someone were to add information in sheet 3 and indicated the intended publication date was 6/2, once the add to upcoming workflow button is hit, i'd like the info to populat the queues under the last entry in the month of june.

Hope this helps. I'd really appreciate some feedback on this. Thanks so much in advance.

Brand_New2VBA · May 18th 2011

Hi Guys,

I need some help with this code. So far I got the values to paste after the last entry in the range, however I'd now like the the values to paste according to the month. for instance:

May June July
hat Cat Dog
5/1 6/2 7/3

I'd like the info from sheet 3 to be copied and pasted to its respective group. for instance:

Jack
6/2
I'd like ths info to be copied and automatically pasted under the "June" group after the last entry for june.

Is this possible?
so far i have this code

Code

If Sheet1.Cells(Rows.Count, "c") = "" Then
    nextrow = Sheet1.Cells(Rows.Count, "C").End(xlUp).Row + 4
    If Sheet1.Cells(Rows.Count, "c") = "" Then
    nextrow = Sheet1.Cells(Rows.Count, "C").End(xlUp).Row + 3
    vntCloneValues = wksSource.Range("F15:F20").Value
    wksDestination.Range("C" & nextrow).Resize(UBound(vntCloneValues), 1) = vntCloneValues
    Erase vntCloneValues
     Sheet3.Range("F15:F20").ClearContents

but it just pastes it into the listed range. The code does everything else right except for the most important thing.

Any ideas???
Can someone help me out with this?

Brand_New2VBA · May 17th 2011

Re: Copy and paste macro with sorting and arranging capability

OK OK! I take it back.

Thanks a bunch for your help I really appreciate it.

I will take your advice on duplicate threads.

Brand_New2VBA · May 16th 2011

Re: Cut and designate paste clone values after the last entry in the column

Hi Craig,

I've cleaned out my inbox. You should be able to reply now.

Brand_New2VBA · May 16th 2011

Hi Guys,

I recorded a macro that cuts and pastes a specific region from sheet 1 to sheet 4. How do I now specify the code to only perform that function if the word "published" is in that specific region. This is the macro I have so far

Code

Range("B4:E11").Select
    Selection.Cut
    Sheets("2011 Publised Workflow").Select
    Range("B4").Select
    ActiveSheet.Paste
    Columns("B:B").EntireColumn.AutoFit
    Sheets("Upcoming Workflow").Select
    Selection.Delete Shift:=xlUp
End Sub

Also, how do I tell the macro to paste the information that has been cut under the data that was lasted pasted--rather than paste over the exisiting information.

Can someone lead me in the right direction?

Brand_New2VBA · May 16th 2011

Hi,

I'm looking to write a code that cuts data from one sheet and pastes format into another. When data is pasted with formats included I want to have it pasted at the bottom of the last entry in the column? So far this is what I have

Code

Dim wksSource As Worksheet
    Dim wksDestination As Worksheet
    Dim vntCloneValues As Variant
    
    Set wksSource = Sheet3
    Set wksDestination = Sheet1
    
    vntCloneValues = wksSource.Range("F7:F12").Value
    wksDestination.Range("C").Resize(UBound(vntCloneValues), 1) = vntCloneValues
    Erase vntCloneValues
End Sub

Display More

Can someone help me perfect this code to make it do what is needed?

Thank you!

Brand_New2VBA · May 16th 2011

Re: Copy and paste macro with sorting and arranging capability

Oops,

Will do!

Too bad you didnt have any advise on my question.

Thanks!

Brand_New2VBA · May 16th 2011

Hi All :smile:,

Is there a macro that will allow me to copy and paste information from one sheet to the other into a speific area.

So far I have the following code:

Code

Private Sub CommandButton3_Click()
Dim wksSource As Worksheet
    Dim wksDestination As Worksheet
    Dim vntCloneValues As Variant
    
    Set wksSource = Sheet1
    Set wksDestination = Sheet2
    
    vntCloneValues = wksSource.Range("C5:C10").Value
    wksDestination.Range("B8").Resize(UBound(vntCloneValues), 1) = vntCloneValues
    Erase vntCloneValues

Display More

However I would like the information that is copied to be placed in the last available queue in its respective column. The columns on my spreadsheet are arranged by date. So if the information that needs to be copied from sheet 3 to sheet one needs to go in the columns designated for "May" how would I be able to incorporate that into my codes? Is it possible?

Also, is it possible to transfer a group of information (cut and paste rather than copy and paste) and have them show up in a separate sheet under its respective month? When the information is cut out of sheet 1--for example--is it possible for the rows to shift the information (if any) below the cut cells up?

Your help would be greatly appreciated. Thank you in advance. :rose:

Brand_New2VBA · May 12th 2011

Hi All,

Attached is a project that I am working on. It is somewhat complete however there is a concern. The copy and paste formulas that I have written seem to take long to complete. If you hit the "Submit Workflow Detail" it seems as if the copying function searches through each field as opposed to only the fields that have been filled in. Is there a macro that will allow the copy and paste function to apply only to the fields with data? Although this will be an interactive spreadsheet that is frequently updated--I need the info to only copy the fields that have information in them.

Can anyone help with this?

forum.ozgrid.com/index.php?attachment/38256/

Thank you in advance. :smile:

Brand_New2VBA · May 11th 2011