Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. marshybid

    Formatting text to be used in calculations

    Thanks Skip, Sorry I'm new to VBA. I have a piece of code that I use to iterate through my worksheet to remove unwanted data. Set myBaseWorkSheet = ActiveWorkbook.ActiveSheet Set myBaseRange = myBaseWorkSheet.Rows For RowsCounter = myBaseRange.Rows.Count To 2 Step -1 Set myBaseRow =...
  2. marshybid

    Multiple If statement not working in code

    Thanks Skip I made the changes you suggested and it seems to be working fine now. Am I able to mark this thread as closed (solved)? Marshybid :o)
  3. marshybid

    Formatting text to be used in calculations

    Hi All, I have a set of data that is delivered to me with a number of the cells containing the folloowing information; 0 HRS 18 MIN (example of one cell) 5 DAYS 4 HRS 3 MIN (example of another cell) These cells are formatted as general. I need to be able to use the days, hours and minutes...
  4. marshybid

    Multiple If statement not working in code

    Hi There, I am new to this forum and would like to request some suggestions for making my macro work correctly. I have a set of data that I need to sort and create pivot tables with 2-3 times per week. I will insert the code that I am using for reference. The issue is that when the data is...
  5. marshybid

    Sorting Pivot Items in a pivot table??

    Hi there, I am struggling to sort pivot items in the correct order in a pivot table. Code below: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "'Raw Data'!R1C1:R8000C47", Version:=xlPivotTableVersion10).CreatePivotTable _ TableDestination:="'Overview Summary'!R3C1"...
  6. marshybid

    Remove and paste data from worksheets using a collection?

    Hi, I'm trying to use the following code to paste data from one worksheet to another and then remove the data from the original worksheet. It doesn't work as I don't think the collection function alloows .add (code below) Can anyone suggest a method/fix. Thanks, Marshybid Sheets("Raw...
  7. marshybid

    Remove Pivot Items in Pivot Table

    Hi All, New to this forum, but hoping someone out there might be able to help me on this. I am relatively inexperienced with VBA, but trying to get through things by trial and error. I have written a macro that will create 2 seperate pivot tables, each representing the raw data in slightly...
  8. marshybid

    Remove Pivot Items in Pivot Table

    Hi All, New to this forum, have tried VBA Express but doesn't seem like anyone there has an answer to this one. Hoping someone out there might be able to help me on this. I am relatively inexperienced with VBA, but trying to get through things by trial and error. I have written a macro that...

Part and Inventory Search

Back
Top