# tedious

1. ### Copy and paste transposed - help please

I am relatively new to this so please have patience. I have an excel spreadsheet with about 150,000 values in column A (so A1 to A150000). I need to copy 10 of them and then paste them transposed into the 10 columns to the right (B through K). Currently I am selecting the 10 (A1 to A10)...
2. ### VBA Macro to automate a tedious task - fast help needed

Hello guys, I am doing some tedious data entry work on excel. Please have a look at the following image: I have been given the task of creating a huge number of excel files. My task is to: 1. Copy and past data (which is "a,b,c,d") into cells J5:J24 as shown above. 2. Based on the abcd value...
3. ### Sumproduct or IndexMatch Function

Attached is an example file. I have about 100 tables of data I need to sumproduct. All are formatted the same but in the same vertical formation as shown in the sheet. I have been cutting and pasting, making them horizontal, but it is tedious to do for each month. Does anyone know of a way to...
4. ### Shorten formula that adds two cells if condition is met

Hello everyone, I have this situation: =IF(Bdg!\$B\$9=1,Sch!AJ8+Sch!AN8, IF(Bdg!\$B\$9=2,Sch!AJ16+Sch!AN16, IF(Bdg!\$B\$9=3,Sch!AJ24+Sch!AN24, ..., IF(Bdg!\$B\$9=12,Sch!AJ96+Sch!AN96) where Bdg(B9) has the number of the current month and Sch(AJ+AN) have values to add up in a pattern of 8 rows apart for...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back