manual

Hi, I have 4 tabs and need a code that can do the following (output to be pasted into Sheet1); (Tab names are Sheet1, Manual, AA, BB) (Sheet1 has dynamic number of rows) 1. If cell F1 in Manual = 1 then copy range A1:N15 from AA and paste this table into Sheet1 exactly 31 rows below the last...

Hello all, I have 2 different tabs in a Workbook. In sheet1 I have all the dates starting from A1 and so on. Now in Sheet2 in B2 i need the 1st cell say Sheet1 A1 but the next value from Sheet1 A2 i need to be entered in Sheet2 but in B12. The next will be Sheet 1 A3 to be entered in sheet2 B22...

I have a spreadsheet that has product pictures and data like sku's, cost, etc. But the person who created it did not format the pictures to move and resize with cells. Can I correct all pictures via a macro? Don't want to do hundreds of manual corrections.

Hi Friends, I have one userform, wherein i required user to capture manual time. Kindly guide me how can i create the Manual time picker in excel userform.

I am sure I am making a very simple mistake but can't seem to find the solution. I am using this formula: =IFERROR(IF($F3="GTS",$M3,(IF(AND(H3="Manual",F3="GTS"),I3,""))),"") I need to differentiate between manual entry and formulated inputs. Column H has the option to select 'manual' for...

Hello I have a vertical column that I want to add and have a total at the bottom. How do I set up the formula so I can just do it once and copy it down the rest of the column so I don't had to manual click on every one of them? Thank you

Hi All, I am currently working on a setup where I would like to filter 3 columns and copy the resultset to another sheet (insert below last row) Sub STEP2_Copy_new_contracts_to_manual() 'copy contracts which are indicated as COPY TO MANUAL from tab POWERBI_IMPORT to Manual map AGR-Crop Dim...

I have created spreadsheets to use as timesheets. our supervisors adjust and create new workbooks every week. On occasion the calculation option has defaulted back to Manual. Why is that? It does not happen very often.

Hello, This code will aloow me to defer pivot table updates on a single table: Worksheets(1).PivotTables("Pivot1").ManualUpdate = True I have six pivot tables on various sheets and I want to make changes to all of them first before refreshing all in one go. Is there simple way, without using...

Hi, Is it possible to prevent manual entry in a selected column and use the same column for bar code scanning?

Hello. Is there a way to have calculations set for manual if the user selects a particular worksheet/tab in the file (i.e tab name is "Example A") & when the user selects any other tab/worksheet in the same file, calculations are set for automatic? Also is there a way to display in a cell if...

Hi Guys, let´s imagine this. In first sheet I have in these three columns A, B, C these values: Column A: car boat Column B: red green Column C: automatic manual How the statement will look like if I need to get respective value into second sheet to the cell D2 and E2? If I write to the C2...

I have a workbook that needs to be set to Manual calculations with the "Recalculate before saving" button unchecked due to the data warehouse add on. This is exclusive to this file. However, I opened another file and this setting migrated to this workbook and now when I open ANY file, this...

I need to clear the below data except formula in sheet(invoice) after I copy data into sheet(report). The sheet (invoice) will be protected by locking some of the cells for any editing. If i protect the worsheet there is no way my macro can run. In Column B7 - manual data input Column B9...

Firstly, thanks for your help in advanced. I am a newbie in this forum and am a basic macro editor. My apologies if any of my post / codes doesn't make sense. I am currently working on a report which has huge amount of raw data and formula referencing to multiple worksheets. The report is being...

Hi, For example, I have a string of data that I need to extract info from but I can't use text to columns. So example, I have "Manual check No: 00000 Check date 1/1/2001" so in A1 for example (say the info I am extracting from is in C1) I want just the "00000" and in cell B1 I want just the...

I have a couple of spreadsheets that run some validation code when the 'BeforeSave' event is triggered. With the new autosave functionality (saving the document to Sharepoint on a very frequent basis), this causes two problems; (a) the code errors out, because the save still happens with the...

My data are like This <tbody> TotalFeed Col1 Col2 Col3 Factor1 Factor2 Factor3 100 (sc-1) 50 25 25 =50/100 =25/100 =25/100 100 (sc 2) 70 =70/100 ? ? 100 (sc-3) 70 15 =70/100 =15/100 ? </tbody> As a matter of math its easy the 30 % remaining will be allocated as 15% and 15 % ...

Hey all, I'm trying to build a new spreadsheet and I need some help to take the manual process out of the report. Essentially I have a large report for “year to date sales”, and I need to find out how many were done, by who, per month. I also need to add up the totals of the sales for each...

Hello, I would like to set manual calculation when a workbook called "AMS" is activated. The other workbooks should be always in automatic calculation. Moreover if the workbook called "AMS" is activated and then closed and saved..the other workbooks should always be in automatic calculation...