The discussions

Vba error -2147417848 (80010108) automation error

So I am trying to make a spreadsheet that tracks our usage by diameter and individual serial number. I perform some basic checks using conditional for...

8 replies Last reply on 10 Feb 2020 by
Tbonekiller

Copying data from one excel sheet to another.

 Solved/Closed

Hello, Newbie here. Okay, I have an Excel workbook that houses a form on the first sheet. What I'm trying to do is to automatically copy the da...

30 replies Last reply on 10 Feb 2020 by
Kav

Copy rows from excel to another sheet once a date in a specific field is filled

 Solved

I have a current spreadsheet that lists our customers, job names, and delivery dates for the materials. I would like to have those lines copy automati...

16 replies Last reply on 3 Feb 2020 by
vcoolio

Cells copying and pasting in a empty cell of another sheet

 Solved

Hello, One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand" In sheet "source" one cell (a1 for example) must...

1 reply Last reply on 30 Jan 2020 by
TrowaD

Punching time

 Solved

Hi again! I have this task ofcalculating the punching time of our agents. I have 4 sheets in one excel. "Deliveroo Data" This is where the orders ...

16 replies Last reply on 24 Jan 2020 by
luigidelmonte

Date am and pm but need the date to change

 Solved

Hello, I have 12 workbooks, what I am trying to figure out is I have the date and time in one cell. But I has it 1/1/2020 00:00 then them next lin...

2 replies Last reply on 14 Jan 2020 by
TrowaD

Copy x rows y times and then insert customer id on each set of x rows

 Solved

Hello, I have a set of criteria, 56 criteria as of now, and I have to check how many criteria each customer meets. In one tab I have the list of the ...

1 reply Last reply on 14 Jan 2020 by
TrowaD

Transferring data autonomously to another sheet with certain text

 Solved

Hello, I want to copy the words "Pending" and "Candidates" from my main sheet called 'Test Project' to my new sheet called 'Pending Test'. Bot...

2 replies Last reply on 17 Dec 2019 by
TrowaD

Averaging data on inserted rows in excel

Hello, Please after successfully inserting specific number of rows in excel, is there any code that can help you average the data on the inserted ...

16 replies Last reply on 17 Dec 2019 by
TrowaD

Calculating normalized standard deviation in rolling window

Hello, Please how do I calculate normalized standard deviation in a rolling window for positive and negative values?

6 replies Last reply on 12 Dec 2019 by
LamoIdiot5

Populate data from a column in one worksheet to a cell in multiple other sheets

 Solved

In a workbook, I want to be able to copy all the cells in column B of sheet "Raw Data" into multiple copies of an existing template sheet correspondin...

4 replies Last reply on 11 Dec 2019 by
Vee1893

Extracting images from a database but named with a specific cell content.

Hi there people! I could use some help... I'm currently importing product images from a database into Excel using the Visual Basic code below: ...

20 replies Last reply on 10 Dec 2019 by
TrowaD

Find out date filling cells

 Solved

Hi, First of all thanks for your help I have a big excel file which I have been filling it for the last 2 years. There is a way to find out the da...

5 replies Last reply on 6 Dec 2019 by
Marcus

How to hide text in a excel cell and display it when needed

 Solved

Hi friends I have doubt in excel. I have a column called 'Status' and want to show the text either as 'Pending' or 'Completed' depending on the ...

1 reply Last reply on 25 Nov 2019 by
TrowaD

Seperating time from text

 Solved

Hello, I have a task in my office that i can't get done and it is very impossible to finish within 1 week as these are 14,000+ orders. The sheet ...

1 reply Last reply on 25 Nov 2019 by
TrowaD

Adjusting code transfer data from combo box & textbox into userform to sheet

Hello, i would help adjusting this code it doesn't work it gives me error when i transfer data to sheet i want to begins transfer dat...

12 replies Last reply on 21 Nov 2019 by
Facebook

Conditional formatting to show when job is done

HI, I have work tracking file. all is running good only i want to have conditional formatting in it. for example:- in sheet dme, column f12:f50 is...

1 reply Last reply on 18 Nov 2019 by
TrowaD

Excel project

I’m in pompano beach Florida searching for a freelancer for this excel project. Not much success yet. Any help would be appreciated

1 reply Last reply on 18 Nov 2019 by
TrowaD

Update master / summary tab with all new entries in other sheets / tabs

Hello, I have a workbook with 9 worksheets; one of the sheets is the master; created to be the other 9 sheets compiled into 1. I need to set it up...

4 replies Last reply on 18 Nov 2019 by
TrowaD

Working on the same workbook from 2 locations

Hello, my name is Marshall and I'm a Logistics Planner. I have created a load schedule on Excel for every day of the week, depending on how many vehic...

2 replies Last reply on 12 Nov 2019 by
Facebookidioits

Vba: delete empty rows based on value of cells

 Solved

Hello, my code works transfer my invoice from sheet1 to sheet 2 but my problem i would adjusted my code to become delete rows from a19: e32 i...

15 replies Last reply on 4 Nov 2019 by
TrowaD

Excel linking to word

Hello, Please I need assistance, I want to link and excel worksheet to word document and be able to edit it on word without having to open the excel...

3 replies Last reply on 2 Nov 2019 by
HelpiOS

Transfer data from one excel file to another

Is it possible to transfer specific data using a formula from a single worksheet in an excel file to another worksheet in a second excel file?

1 reply Last reply on 2 Nov 2019 by
HelpiOS

How to simply this excel formula

 Solved

Is there a way to make this formula simpler? =IF($K9=0,"",SUM($L9*$L11)/R9+IF($K9=0,"",SUM($M9*$M11)/$R9+IF($K9=0,"",SUM($N9*$N11)/$R9+IF($K9=0,"",...

3 replies Last reply on 28 Oct 2019 by
TrowaD

Vba compare 2 sheets and output difference to 3rd sheet

Hello, I am trying to make a button on VBA that will take compare two excel sheets, and identify new numbers in a certain column and copy and past...

3 replies Last reply on 22 Oct 2019 by
TrowaD

Serial numbers

Hi, Can someone help me create a series of numbers? I ran out of numbers. Please help me do this numbers. I need maybe 5000 numbers for this. here is ...

2 replies Last reply on 20 Oct 2019 by
luigidelmonte

How to check if a cell contains "%" and calculate accordingly.

 Solved

I am wondering how to do that? I learnt no basics, just went on by myself trying to figure out things and so here is what I am trying to do.. Ba...

7 replies Last reply on 18 Oct 2019 by
Saurabh

Findall this custom function returns find and findnext results as an array of va

Find All This custom function returns Find and FindNext results as an array of values. It will find all the instances of a string (sText As String) a...

1 reply Last reply on 17 Oct 2019 by
TrowaD

Vba stops running when it reaches a blank cell

Hello Everyone, I have an Excel spreadsheet that I am preparing for use. In the spreadsheet, i have a VBA macro set up to transfer out data from t...

1 reply Last reply on 15 Oct 2019 by
TrowaD

Vba copy/paste fixed range a number of times

 Solved

Hello Team, I'm looking for a VBA code to copy the three rows and with input box paste based on the times, I entered in the input box. FOr ex...

6 replies Last reply on 15 Oct 2019 by
TrowaD

Excel - if function with multiple words

 Solved

Hi I'm trying to write a formula to produce a yes/no answer depending on whether the data in a previous cell in the same row contains any of the wo...

14 replies Last reply on 8 Oct 2019 by
user

Calcul de prévision des livraisons de colis sur les deux prochaines années

Bonsoir, J aimerai faire une projection sur Excel pour les 2 prochaines années,pour ce faire je dispose des données des livraisons de colis pour 2027...

1 reply Last reply on 3 Oct 2019 by
TrowaD

Mac: copy rows to master sheet based on cell condition

I am an insolvency professional. I keep details of processes to be conducted on different companies alongwith their time lines. The different columns ...

4 replies Last reply on 3 Oct 2019 by
TrowaD

Adjust code show message about brand

hi i would helping to adjust my code i have data in my sheet a,b ,c columns a= item , b= brand, c= quantity and userform textbox1,2,3 when...

5 replies Last reply on 3 Oct 2019 by
abdelfatah_0230

Find a date in a range of dates

 Solved

Hi All. Another silly Macro question that I cant seem to find an answer for ... As my wife does silly shift at work I have developed an excel sp...

4 replies Last reply on 2 Oct 2019 by
BrianGreen

How to merge bank statement into one column

Hello, how can I merge bank statement credit transaction with debit transaction in excel into one column? Considering credit transaction should be i...

3 replies Last reply on 30 Sep 2019 by
thanks_4_nothing

Excel vba sorting problem

Hello, This code is placing all the header names in the last row after sorting in descending order. Can you please help how to keep the position of ...

3 replies Last reply on 29 Sep 2019 by
vcoolio

Copy data to a master sheet from newly created sheet

Hello, I have a master sheet that I want to automatically fill. I have a macro that creates a new sheet for each instance, I now need another to ...

1 reply Last reply on 24 Sep 2019 by
TrowaD

Creating graph that updates

Hello, I am keeping track of how many work orders are being created each month. On my "Completed Sheet" in column F it has the due dates. I would ...

6 replies Last reply on 21 Sep 2019 by
vcoolio

Vba sum data between 2 sheets

hi, expert i have sheet1 contain data from range a4:e and the sheet2 contains data from range a3:g i would sum the data in sheet1 from b4:e and s...

5 replies Last reply on 19 Sep 2019 by
TrowaD

Need to extract the data from one page to another page based on the unique numbe

Hi i have data like below mentioned format, need to extract and paste it in another sheet, please help me in it. DEAL_NO DEAL_DATE APPLICATION_OFF...

1 reply Last reply on 17 Sep 2019 by
ac3mark

Vba coding

I had a file with 2 sheets say 1,2. From 1st sheet I want to copy one by one cells of A column whose value is OK in C column and paste it in C1 of sh...

1 reply Last reply on 9 Sep 2019 by
TrowaD

Arrow keys not working

Hello, my arrow keys are not working. up down left right

1 reply Last reply on 9 Sep 2019 by
Ratnendra Ashok  

Unable to change date format in excel

 Solved/Closed

Hello, I have an excel worksheet with a date column, the format is set to dd-mmm-yyyy but the dates in the columns display as mm/dd/yyyy. If I doubl...

39 replies Last reply on 6 Sep 2019 by
Tobby

Excel 2013 to extract text in one cell

Hi, I want to extract in the right column, a part of the left column, for instance: see below 2 lines for each line at the right column I want to ext...

1 reply Last reply on 5 Sep 2019 by
TrowaD

How to transfer data from sheet to sheet 2

Hello, I have created an excel file which I need to track progress of each order, in the first sheet I have created the list of things that needs ...

9 replies Last reply on 3 Sep 2019 by
TrowaD

If statement

 Solved

Hello, I am really struggling to get the correct formula for below situation: example: Cell A2 is a "due date" Cell B2 is a "completion date" ...

4 replies Last reply on 30 Aug 2019 by
ac3mark

Dynamically assign a number in data set

Hello, I have a large data set and need to assign a number to each row if the status changes. Is there a short cut / dynamic way that I can assign...

3 replies Last reply on 29 Aug 2019 by
TrowaD

Transfer data from userform to sheet with the same format of table

hi, experts i have userform contains 3 textbox and sheet1 contains table i designed from 3 columns i would every time when fill data in userform ...

7 replies Last reply on 28 Aug 2019 by
ac3mark

How to find the latest time per name in a table with names and times

 Solved

Hello; I have a sheet with a list of "use name" and "time" (which is a login date). I need to find for each user the latest date . But users have sev...

11 replies Last reply on 27 Aug 2019 by
TrowaD
Results 251 - 300 out of a total of 7,061