Hello All.
I am not the best excel user but definitely not brand new to excel, and if something like this has already been answered just direct me to that thread.
I have a very large proforma spreadsheet that I am using to track our company's estimate/cost per job vs overhead spending vs...
Not even sure excel is able to do what I want this way but I'm trying to take data that's in Column D on sheet "RemoveDup" and copy it to Row 2 on sheet "Final" using a VBA. If the VBA finds a blank cell in the RemoveDup Column the VBA ends.
So the below code "works" in the sense that it moves...
So, I am fairly competent with excel formula but no nothing about macros. I have just received 35 separate pdfs which I think will convert to around 15000 rows of data in excel. I think it will take me hours (if not days) to formulate the data in to a usable table without some kind of excel...
This is my raw data:
https://drive.google.com/file/d/0B_WMlJ39MlmaUXhENnFlNDVLeGc/edit?usp=sharing
I want to get to something like this:
https://drive.google.com/file/d/0B_WMlJ39MlmaNG1vZ0ttdnVFUlk/edit?usp=sharing
How do I do it? I cannot get the formula to repeat. I'm using the following...
Hi all,
Could you please help me with this case:
I have Group name in one column and Item name in other column. Each item belongs to respective group in the on the left cell.
We want to have Group name as Column header and all items belong to the group in the column.
I tried transpose...
I am using excel2007 and i have 2 sheets in my workbook
on the first sheet i have the input data sheet
Name ____
b-day ____
age ____
sex ____
and an encode button with the syntax like this...
inputdata = Sheet2.Range("a65536").End(xlUp).Column + 1
Sheet2.Cells(inputdata, 1).Resize(1...
Hi guys, I wish to copy data from row to columns recursively. All I know is how to record macros. Kindly, help me edit the code.
Eg.
The data is in the following format, it is in one single column.
BRANCH1
ROW11
ROW12
ROW13
ROW14
ROW15
ROW16
;
BRANCH2
ROW21
ROW22
ROW23
ROW24
ROW25
ROW26...
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.