tedious

  1. J

    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. A

    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. K

    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. A

    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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top