please help

I am having an issue writing a macro that will copy 3 rows of data and insert it into another column, every 10 rows starting with row 9. Ex: Copy rows 2-4 on Sheet 2 and insert into Sheet 1, row 9. Then copy rows 5-7 on Sheet 2 and insert into Sheet 1, row 19. Etc… I hope this makes sense...

I have a simple sum formula with data linked from another workbook I would like for it to carry over back to zero every time the sum reaches 120,000. For example if the value input summed 150000, I would like it to read 30,000, and have some notification that it has went over once. Is this...

Hi- I'm sure someone has asked this before and I've been looking through the forums, but haven't found a fix for my problem. I have 6 bonus hurdles If cell value is 75,000 - 114,999, then 1% = bonus If 115,000 - 154,999 , then 2% = bonus If 155,000 - 194,999 , then 4% = bonus If 195,000 -...

I have one question which is bother me for quite some time. Is It possible to make this kind of a chart with pivot chart where the blue columns are the total sales received in one hour interval for example between 13:00 and 14:00 and so on, and then the red line to show me how the orders ware...

I need a macro that will copy Column A in Sheet 1 to the next empty column in Sheet 2. I need to keep the same formatting in the destination cells. I need to do this several times and store the data in Sheet 2.

Someone please please help me with this formula on #5. I, for the life of me, can not figure this stuff out! I need help with the first 3 sentances of #5 and all of #7 I have attached a link to my workbook as a google doc, the format is Excel 2010 and here are the questions for the workbook I am...

Hello, I've imported some data from matlab into excel and much of the data contains an imaginary component which I do not want can anyone help me think of a way to get rid of all of these? There are about 2000 data pieces so I don't want to do it manually. Thanks for your help in advance.

So this for loop was previously working but with new data set has decided not to work. Please help! For x = 1 To x = n Qx = Worksheets("Working").Range("Qx") If I * x = I * (x + 1) Then Qx = " " End If Next x I want it to look in column Q and if the data...

Good Day, I'm attempting to count the number of people who fall in a range of time... My current formula is not working - I've tried two. On the Sheet 'march hc' row E contains start time 1:00:00 PM as an example while row F contains the stop time so 8:30:00 PM. Row G contains day of week so...

hELLO I'M LEARNING EXCEL AND NEEDING TO KEPP TRACK OF JUST OVERTIME HOURS. i HAVE COLLUMN A1 WITH 31.50 HOURS COLLUMN B1 WITH 43 HOURS AND COLLUMN C1 WITH 42.50 HOURS MY NEXT COLLUMN D1 IS SUPPOSED TO BE THE TOTAL OF ONLY EVERYTHING OVER 40 HOURS WHICH SHOULD BE 5.50 CAN ANYONE PLEASSE HELP ME...