Search results

OK here is some new code and it finds each instance of the Employees Name and pastes it in column P. Now what I want to do is copy the name in say cell P3 down to the next name. So the name in cell P3 would be copied from cell P4 thru cell P24, then the name in cell P25 would be copied until the...

One more thing the name is located in column C.

Let me ask this: The key word I am looking for is "Employee Name" in column A, if "Employee Name" is found in column A I want in cell P3 that name to be populated there and in each below that until it finds another "Employee Name" then repeat until the end of the list. Maybe this will help.

OK, I have tried the suggestions and end up with the same result. SirJB7, at the first stop P3 thru the LastRow are selected. Then a run-time error 1004 No cells were found is displayed. Same for DebraJ. If all those #N/A's between the names would only fill with the name in cell P3, P36 and...

Here is the situation, I have a macro that writes an IF formula to the last row then does a copy/paste value. There will be an actual value in say cell P3, then several blanks and an actual value in cell P10 and so on. The number of blank cells between the cells with an actual value varies. The...

Luke, That is correct. The Access DB is tied in "Live" to the secure database, so it does auto refresh. The Excel tool runs fine on my PC but errors out on someone else's.

Hello and thanks for reading. I have an Access DB, that is tied into another secure DB, that I use to summarize some data. Because I need the data from the Access DB query over in Excel, I have a macro in Excel that retrieves the data and puts it in a worksheet. My issue is I want other...

Narayan, Exactly! I found out that the time on the server and the time on my PC was off. They were not synced up. IT ran a update and now all is fine. Thanks everyone for your help! Mike

Here is the script: Option Explicit Dim xlApp, xlBook Set xlApp = CreateObject("Excel.Application") '~~> Change Path here Set xlBook = xlApp.Workbooks.Open("\\abc1hb2\data\Phone Stats Macro V2.xls", 0, True) xlApp.Run "PhoneStatsV2" xlBook.Close xlApp.Quit Set xlBook = Nothing Set xlApp =...

I have some VB Script that I run through Scheduled Tasks that runs a macro. The script was running fine until IT done some server maintainence. Now the script only runs during the day when I am at work. Before it would run at 6:45AM before I got to work. I just find it odd that the script...

THANK YOU LUKE!!!! You are a life saver man! Mike

I would greatly appreciate any help please. I have a spreadsheet with the following data: Column C - Name Column F - Amount Column G - Code # Column H - Code Description Issue: One person may have up to 3 entries with only the data in columns F-G changing. How do I get VBA to take and put...

AHHHHAAA! Solved it, go to the Data tab, choose Consolidate. Choose Product then the range of data and include the labels. Done! What is even cooler is using VBA to do it.

I have a spreadsheet where I could have an EE's name listed once with data in columns B & C, they could also be listed again in a second row with data in columns D & E and they could also be listed again in a third row with data in coulmns F & G. Some EE's have data listed only once in one of...

Awesome Luke! I was trying to use COUNTIF. Now I see. Thanks a bunch!

I came across an article "Quarterly totals when you have multi-year data [SUMPRODUCT again]. Here is the link: http://chandoo.org/wp/2010/04/30/quarterly-totals-multi-year-data/ My question is instead of summing up sales I want to count the number of "L"s and "O"'s in the dataset by quarter...

Greetings everyone! I figured I am always asking for advice on here so now I am giving some. I found this code somewhere, Bacon Bits I believe. I had build an Access database that is tied live to some other software we have. I needed an easy way to extract data and to be able to analyze it...

I had a situation where my raw data workbook contained data in columns A:Y. In column R, the data could vary from 5 to several hundred rows and was the only row where if sorted, data would be in only say 50 of 100 rows. The column R data was what I was interested in. So, how do I copy only...

Persistency has paid off. I finally was able to accomplish my task.

I seem to be on my own here so I have been trying. The below code works but it copies all the data from FileName instead of just "Team 2" to the "Team 2" tab of the Sample Template. At least it is some progress. ----- Workbooks(Filename).Activate Set Rng1 = Range([B1], Range("B&#34...

Here is the situation. I have a report that I run we will call "Report". I have a macro that opens the report once it is saved in its file location. The macro opens up a template called "Master Template". The "Master Template" spreadsheet has four tabs named Team 1, Team 2, Team 3 and, Team 4...

IT WORKED! IT WORKED!!!!! THANK YOU SOOOOO MUCH FOR HELPING ME! You were very patient. Thank YOU!!!

I'm getting it like this: Sub ChooseFile() Dim fd As FileDialog Dim FileName As String Dim lastRow1 As Long Dim lastRow2 As Long Set fd = Application.FileDialog(msoFileDialogFilePicker) 'Get the number the button chosen. Dim FileChosen As Integer FileChosen = fd.Show If FileChosen...