Need Macros or If/Then Statement To Match Data from one column into another Please

Normally I get a super fast response. Can anyone please help? I really need to get this column recoded so I can finish up some GLMMs.
Thank you!

Oh I'm sorry! Let's see if I can elaborate.
CGEvents has counts of events that happened each month to each group (R1, R2, PB). I need these moved over into the column P in NBdataC so that P2 will have the correct number based on it's B2 & F2. In this case, 12 (because in CGEvents, R2 in the month of Feb has 12 events occur). This row happens to be correct only by sheer luck. I think all of Feb data may be correct for all groups, but the subsequent months are wrong. And while this NBdataC file only has a few of the months I need (due to file size constraints), the full data file will have all 11 months. So any code would be adapted to apply to all 11 months.

I have the exact same data in two forms in CGEvents because of a prior data need. I left both because I wasn't sure which would be easier to utilize to get the needed data pulled over. Does this help?

No they don't anymore. They did with the original data file but that was several files ago and I have since changed them up. (Honestly, I don't know why I setup CGEvents columns BC the way I did - it just wound up causing more problems - but this is all a learning process i suppose).

Hi,
Yes the data in E3-H13 is the same as columns ABC, if it is easier, you can use those.

The CGEvents file is only a reference file, it will not be used in data analysis. NBdataC is what the data file will look like, but I had to delete about 40 columns and 20k rows in order to make it small enough to upload here. When people help me out on here I take the code and adapt it to the full data file.
Does this help?
Thank you!!

Thank you! I am getting an error though:
Error: Run-time error ’429’ ActiveX component can’t create object

On line:
Set Arr = CreateObject("System.Collections.ArrayList")

I forgot to mention that I am a Mac user - I feel like I have seen this error before. =(
I need to add this into my signature so I stop forgetting to add it in. I'm sorry, is it possible to fix it?

I completely understand! Thank you! I wonder if I should create a new thread or if someone will see this?

Originally Posted by sintek

if you like....remember to post the link to this thread....
Use this as subject header..."run-time error ’429’ activex component can’t create object windows vs mac"

thank you!

Originally Posted by sintek

Try this conversion...

Please Login or Register  to view this content.

Oh my gosh that worked! Thank you sintek!!

Originally Posted by sintek

Try this conversion...

Please Login or Register  to view this content.

And I just tested it on the big file - I got it to work perfectly. Thank you for saving me days of hand coding! I wish I could rate you twice!

Any chance someone would be able to "convert" this for Mac compatibility for me? :D

Sub FolderSize()
Dim fso As Object, fsoFolder As Object
Const strFolderName As String = "PathName"

Set fso = CreateObject("Scripting.FileSystemObject")
Set fsoFolder = fso.GetFolder(strFolderName)

MsgBox fsoFolder.Size & " bytes"

Set fsoFolder = Nothing
Set fso = Nothing

End Sub


Works fine on Windows, but the Set fso = CreateObject("Scripting.FileSystemObject") spits out the Error: Run-time error ’429’ ActiveX component can’t create object

I apologize, please ignore my post then