Get value from Nth row convert value and paste result in different sheet

GaithS

New Member
Joined
Jan 17, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have created an excel file where employees can create projects and follow an introduction process. I want to get the summarized then converted to one cell as green red or yellow.
The status bar moves every 17th row. i want to go to the row get the data from x columns then from y column and summarize in different sheet.

As of now i am using: =IF(COUNTIF(F17:F26;"Röd");"Röd";IF(COUNTIF(F17:F26;"Gul");"Gul";IF(COUNTIF(F17:F26;"Grön");"Grön";""))) [Grön=Green Röd=Red Gul=Yellow]
To summarize column to rows.

And this: =IF(COUNTIF('Uppföljning tidsplan'!F27:K27;"Röd");"Röd";IF(COUNTIF('Uppföljning tidsplan'!F27:K27;"Gul");"Gul";IF(COUNTIF('Uppföljning tidsplan'!F27:K27;"Grön");"Grön";"N/A")))

To get the sum from rows and get an overview.

I hope you can understand my problem if not please ask.

I want to make this in to VBA. thanks in advance
 

Attachments

  • Overview.PNG
    Overview.PNG
    40.2 KB · Views: 11
  • Project.PNG
    Project.PNG
    80.3 KB · Views: 12

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,560
Latest member
Torchwood72

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