manually

hi all here the sample: https://drive.google.com/open?id=1K8XzfwXLt79yqeQS2u6YJYw9E_g44w1M the row 8 have the TOTAL sums of each column, and in the row 9 add the minutes to hours. i captured manually the D column, but how to calculate? not understand, any help? Thanks

Hello, I'm wondering if anyone is able to help, as this has started to take up a lot of my time, and I'm on the verge of giving up and reverting to doing it manually. I have a list "Services" which can have multiple "internal services" associated with them. I have the master list, and I...

Is there a way to replace all formulas except subtotals? Currently I'm doing it manually...

ive a workbook that the days never change in A2 i have 10/09/15 (Saturday) and in A3 i have 09/09/15 (Wednesday) in A4 i have 12/09/15 (Saturday) and in A4 i have 16/09/15 (Wednesday) so on and so on so instead of having to put in the date manually id like a formula to do this for me can...

Hello everyone. I need some help with my project where i want to copy array and past it to another sheet. Array is a daily base of consumption for different materials, so would like to copy it to another sheet that i manually name it for a month its made. The problem is i just don't know macros...

Hello everyone. I need some help with my project where i want to copy table and past it to another sheet. Table is a daily base of consumption for different materials, so would like to copy it to another sheet that i manually name it for a month its made. The problem is i just don't know macros...

Hello Excelgurus, I've incorporated a bunch of checkboxes in my workbook. The captions of those checkboxes are the first names of staff members. I've added those checkboxes manually and I also manually changed the caption to that particular person's first name. I was wondering if it's possible...

This is the strangest thing I've seen yet Excel 2016 I have a particular range of cells that, no matter what I do, insist on replacing a formula with the numeric value of that formula UNLESS I enter the formula (manually) with an apostrophe in front of the "=" such as '=SUM(CC3/$BQ$24)...

Hi, Need assistance please with 2 formula to calculate dates and number of working days in a given week. C2: 2019 (manually entered) C8: =IF(WEEKDAY(DATE($C$2,1,1),2)<6,DATE($C$2,1,1),DATE($C$2,1,1)+7-(WEEKDAY(DATE($C$2,1,1)+1))) (returns the 1st Jan if not a weekend) C9:C12...

Is there a way I can automate adding a Hyperlink to every cell in my range which goes down to row 1930? I've used a Macro recorder to do the first one but manually doing this for every cell would be really time consuming: Range("A2").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection...

Hi all, Every month I do some manual calculations, in which I have to manually round number to two decimals to match the invoice amount, here is an example, the second column rounded to 2 decimals, =round(…,2), that comes up to 320.05 but the actual should be 320.04, therefore I manually adjust...

what i have: ActiveCell.FormulaR1C1 = "=IF(ISNUMBER(MATCH(R[0]C[-1],'Hierarchy'!B:B,0))," & Chr(34) & "Exist" & Chr(34) & "," & Chr(34) & "No" & Chr(34) & ")" What i want: =IF(ISNUMBER(MATCH(G2,'Hierarchy'!B:B,0)),"Exist","No") What i'm getting...

I’m not sure if I’m posting this to the right place but any advice I can get will be appreciate. I want to Automate the downloading of files from 2 websites using Excel VBA. The first website Log on page has name’s and id’s for the Log on elements. The problem with the first website is that...

Hi, its probably a very simple question, but i want to generate to following values in the two columns: <tbody> Date Time 01-11-2016 1 01-11-2016 2 01-11-2016 3 01-11-2016 4 01-11-2016 5 01-11-2016 6 01-11-2016 7 01-11-2016 8 01-11-2016 9 01-11-2016 10 01-11-2016 11...

Hi Guys, I've attached a screen shot of example piece of data. I was wondering if someone could help me with piece of work that I'm doing manually. I took me end-less hours to do manually (data set has 6000+ rows) and my vba writing ability is lacking currently. Essentially I need a...

I am working too hard manually. Trying to do a string that will give me the character in the middle between two characters. I need to do a count between / and /// <colgroup><col width="365" style="width: 274pt; mso-width-source: userset; mso-width-alt: 13348;"> <tbody>...

Hey, I have a report that I am creating and which will be sent out daily. I want to paste it as a picture in an Outlook email. I have attempted to use Ron de Bruin's site for help and I have also tried manually copying and pasting it as a picture into outlook. Both times it always cuts off...

I have 2 workbook. 1. Ipe.xlsb 2. Masterfile.xlsx I have the follpwing formula on Ipe.xlsb]B1 ='H:\Prod\[Masterfile.xls.xlsx]Sheet1'!A2 it is not updating unless I press F2 and update it manually. Is there a way to update the link automatically? Or is there another formula that I can use to...

Hi, I have data I download from the internet, in a text like format. my code pastes it into A1, but I would like to do paste as if I am doing it manually. a Copy and Paste works manually but want to get this working in my code. I store the downloaded data in a variable, then write it to A1...

Dear All, I am a mac excel user. Likely an easy fix for a seasoned slicer & VBA user. I have a large pivot table with an linked slicer, with approximately 20k records and growing (500 day). The slicer is fairly clunky to operate. I need to be able to select a specific date range within the...