simple fix - i think?

Probbably a really simple solution to this.. When my coleagues are quoting, sometimes it could be for 10-15 rows others could be up to 500 rows. instead of them constantly adding lines to the sheet and running the risk of removing formulas, is there a way that I can have a row or two where when...

Hello, It's a pretty straightforward issue, I need to paste a set of rows (template), available in the first 3 columns of the excel sheet multiple times, for instance, 500 times, can anyone please help me to that with a VBA Code? I am a very beginner with VBA. Thank you. C4

Hello, please please can someone help me: I have a simple forecasting sheet, where each month a payment is made, until the value reaches £0. The example below, shows two lots of £500 per month - however if the payments were to increase or decrease this would change the month were £0 is...

hello everyone, Fairly new to VBA. I'm only using simple macros. Just wanting some help with a VBA. I want to copy and paste items from the same cell which I change, into the next line after. Here's what I use so far. But I don't know how to loop it so it does the next line down. I hope that...

Hi everybody.. I'm looking for help to update the below code to transpose data from Column format to Row format. I have the below code (thanks Yongle for your help!) that copy values in a set of column cells when a button is pressed and pastes those values onto another tab. If the user...

Afternoon Can this formula be simplified...

Good Day all This is my first post and i am not an "excel engineer" , please bare with me. Essentially i have a row of cells that needs to be identified if it is larger than a certain amount (x for example ) and then X subtracted from it as many times needed to get it below x. I then need...

.1 I'm trying to find a formula that matches the suitability of each worker for the group to which the worker is assigned. Suitability rating Group 1 Group 2 Group 3 Group 4 Assigned to Worker 1 2 3 4 4 1 9 8 6 8 1 2 10 0 5 6 3 3 5 8 10 5 Considered using vlookup, hlookup - but...