Hey everyone,
I have 3 IDENTICAL workbooks (say WB-A,WB-B,WB-C) with 4 sheets in each workbook (say WB-A1,WB-A2,WB-A3,WB-A4 / WB-B1,WB-B2,WB-B3,WB-B4 / WB-C1,WB-C2,WB-C3,WB-C4). These 3 workbooks are basically reports for 3 different projects, which are updated individually on a monthly basis...
Every week I refresh a text CSV file into sheet 1 that has a different commodity for each row and many columns worth of data. I Then take some of the data from sheet 1 and copy it into the next available row (1 row per week) in sheet 2. Using a formula will not work because every time I refresh...
Good Day,
I have a challenge for which I have came to a dead end.
I would like to achieve to generate 3 lists pulled into an "overview" sheet from data across 52 sheets representing weeks.
List 1 would be names of clients called - which would be any non blank cells in the cell references...
I have a spreadsheet with employee time data from multiple jobs by date and craft codes. I am needing to loop thru Sheets "TIME LOG" column "A" if it meets job number that is in Sheet "T IMESHEET" range "P5" then it checks for date in TIME LOG sheet if it matches date in TIMESHEET "P4" then it...
I am using Excel2007 and im having problem in transferring a row of data in my Sheet2 where it is my masterlist to a column of input cells in sheet1.
this is my sheet1
Excel...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.