DirkT
I've tested it few times ... there could be some unwanted features.
My writing Insert new rows ABOVE this one-option won't work
-- means -- it won't work - because this sample uses fixed range.
There are some code for that.
jeanmarcd
Your I need the pdf file to convert to an excel file where each line of the multi-line cell is in its own cell / line.
Could You send a sample PDF-file ... instead of Excel-file?
... as You've written.
DirkT
Okay...
Few minor notes ...
# it's very sensitive with those colors
# dates will refresh after You've moved cursor
# Display week ... changes calendar ... project itself stays in same place (~move)
# I added [ ReFresh All ]-option to refresh all rows (8... 31)
# So far Insert new rows...
Luca999
Okay ... none questions.
Few same notes:
# 'grouping' is missing as I wrote
# my eg ... You answered something else
# That file needs many modifications.
DirkT
Could this sample work someway as You've thought?
# Select cell
# Mark cells (~bars) with colors (which are very sensitive)
# Move Your mouse somewhere
% and dates should update
Luca999
There are still too many 'how this should work?'-cases
... before I could figure - how/which to group something?
... plus many more eg how any 'equipment' could give 'Final Country'.
There should be clear connections between those which could group.
I did 'minor' modifications to Your...
# grap ... yes?
... and have huge file.
As well as there are some dropdowns.
Skipped question: How You control that data is there once?
# Naming ... really? check below snapshot
... hmm? Did You follow 1155?
Do it matter if there will lost some connections with sheets?
# number of those...
Still too many ... hmm?
# grap ... yes?
# Naming ... really? check below snapshot
# number of those interventions ... are different than You wrote or how?
Three questions ... You answered to the 1st one.
but
Only Sheet3 has ID information.
If follows Sheet1's JOB 1155, which have three places for intervention.
from Sheet2 can find three rows data based REFERENCE JOB 1155, which each have ? separate ? three places for intervention - total nine or...
Somewhere is possible 3rd intervention too ... hmm? ... where?
Do You really have already three times same data?
... or How You control that data is there once?
Luca999
Isn't Your 4th sheet layout still horizontal?
If You want to avoid see some columns then those columns could hide for those moments
Or
Do You have an image to show possible 2nd intervention below 1st intervention?
... then do You really need to see those A...E-columns twice?
Luca999
Your 3rd sheet has two extra columns (TYPE & OVERALL STATUS).
... plus there are two times those seven columns.
Why You won't use it?
... or what to do with those other seven columns.
You sample data has many empty cells.
Is Your 4th sheet ... vertical?
... is something else then please...
Yash0071
As You've read all links from
https://chandoo.org/forum/forums/new-users-please-start-here.14/
You've found page
https://chandoo.org/forum/threads/posting-a-sample-workbook.451/
You've found one way - how to use code - tags.
Sairavindra
As You've asked this in Ask an Excel Question
Do below:
Select Sheet1
Select left top corner
Press Ctrl+A
Press Ctrl+C
Select Sheet2
Select cell A1
Press right button of mouse
Select PasteSpecial
Select Transpose
Did You test my file?
Did You check that my code?
That uses only Your named SomeSheetOne-sheet.
... of course, before testing something - have a backup!
prabirmustafi
Why do You need to copy that sheet?
Copy needed range as in my sample.
Compare to this sample.
From where do You have idea to run that my code?
If in other file than that ... sheet is then ... something different.
prabirmustafi
I waited for a sample expected correct txt-file ....
Here one sample (.xlsb-file ) to get txt-file (.txt-file)
... You gotta modify needed SaveAs line there.
prabirmustafi
Have You tried to do it manually (those 7 steps)?
Do it works then?
Have You tried to record a macro with those 7 steps?
... What is different than You're needing?
If You would like to ask about VBA ... then this thread should be in VBA Macros ( moved there ).
Could You send a...