I have just started with VBA and I need your help. I've attached a picture and I will try to explain my problem. In "lastat"-sheet, I will add stock/pallets that I will move to another warehouse. With "Move"-button i move numbers to "Lagersaldo"-sheet. This warehouse will use...
Is there a way i can copy paste specific rows to the excel ark. The things i need:
- copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book)
- has to copy the value in the given row if the cell next to it is empty
- the macro has to be applied from mappe1 (book)
- next month the...
Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is:
Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box
The sheet name...
Hey good folk,
I have a timesheet i get my engineering dept to fill in, we have a lot of customers who's name they have to input when working on a design. The "short" name our ERP system uses is noting like the actual customer name and my guys sometimes get confused.
Anyway i have created an x...
Let me try and explain what I need with a simplified example:
I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality).
I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...
Never encountered this problem before.
Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows...
Thought something was amiss with the file itself so I created a new file and tried to...
Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost).
Is it possible, via M code or otherwise, for me to group by...
I have the 2 tables below:
Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8)
desired results enclosed.
Thanks for the help...
Required a formula help for Filter/Transpose a multiple rows and multiple columns in a same row as per condition met with row headers . Row Headers that contain duplicate row headers and reorder all values or text values from multiple columns into one row.
solution to be needed in Column...
I'm trying to get 2 multiple results from 2 different columns under 1 column and in order.
Column E = Matching Apple in column A -> returning C value
Column F =...
I have a excel sheet with around 5lakh rows and i want to reduce number of rows by cumilating same data.
below is the sample data (Couldn't share original data due to privacy reasons). Data should be combined based on Columns B,D,E,G.
If data present in B,D,E,F columns is same the code has to...
I'm trying to make the formula working on each 2 rows respectively, but I couldn't
FX SWP product is displayed in 2 rows. I want to separate the two rows, and put one in the Short sheet and one in the Long sheet. Each FX SWP has the same Swap Number, with two Trade Number, one will have...
Dim a, b
Dim nc As Long, i As Long, k As Long
nc = Cells.Find(What:="*", After:=Cells(1, 1), LookIn:=xlValues, SearchOrder:=xlByColumns, _
SearchDirection:=xlPrevious, SearchFormat:=False).Column + 1
a = Range("B1", Range("B" &...
I am not sure if this is even possible, but I figured I'd ask/give it a shot.
In a spreadsheet I have a marker (denoted in cells with a * symbol).
Is there a way (without using VBA) to use conditional formatting to adjust the colors of the cells around the marker?
Last time I reached out to you, I felt the love with so many responses so quickly.
I am a teacher and I’m trying to look for ways to streamline my duties.
I'm currently reviewing the courses I teach - focussing on equipment used, and duration for each module.
I have been asked...
I'm trying to write a simple macro that will delete few rows, than sort by values from one of columns and than delete few rows below some value.
I am using the strings of the code just strictly from "record macro" function.
It does have codes like
I have to make a summary of the different times it takes to add a certain product. Right now all the values I have are sorted by date and every date has all the steps. ()
I would like to put all the steps that are the same underneath each other so I can make a scatter plot.
Is it possible...
I have a large batch of data.
There are 5 different types of data. Every 5 rows, there is a new set of data.
I am trying to implement Data Validation Input Messages so that when a user is on a certain cell, they will know what type of data is being referenced.
Not sure if that makes...